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. | - |