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