This wizard is used to export entries to Excel files.
To start the wizard choose one of the following options:
In the LDAP Browser view select an entry or a search and choose Export >
Excel Export...
from context menu.
In the Connections view select a connection and choose Export >
Excel Export...
from context menu.
In the Workbench menu bar select File > Export... and choose
LDAP to Excel
.
On the Data to Export page you have to specify which entries and attributes to export.
The layout of the page is similar to the LDAP Search page . In the Returning Attributes section you can also choose the following option:
| Option | Description | Default |
|---|---|---|
| Export DN | Exports the distinguished name as first column in the Excel file. | on |
| All user attributes | Exports all user attributes. | on if the Returning Attributes field is empty |
| Operational attributes | Exports all operational attributes. | off |
On the Excel File page you have to select the target Excel file.
| Option | Description | Default |
|---|---|---|
| Excel File | The Excel file to export to. Type in the full path or Browse... to select the path on the file system. The drop-down list provides a history of recently used files. | empty |
| Overwrite existing Excel file | If the export file already exist, you must permit to overwrite the file. | off |
| Text Formats | Opens the Text Formats preferences where you could modify the Excel format. | - |