Checking the Excel Import/Export Options
Checking the export Excel import access options
To be able to access Excel import and export features:
1. Open the options window then click one of the following folders:
• Data Exchange > Import > Tools/Third Party Formats
• Data Exchange > Export > Tools/Third Party Formats
2. Check that the Excel (*.xls, *.xlsx) check box is selected.
For more details on accessing import and export features, see:Checking the Excel import/export usage options
Using the import/export wizards
To be able to use the Excel import features:
1. Open the option window and select the folder Data Exchange > Import/Export Synchronization > Tools/Third Party Formats.
2. Check that the option Export Excel: Availability in Listviews is selected.
For more details on the use of wizards, see:Managing languages in the imported or exported Excel files
Object names are by default imported or exported in the current language.
An option enables you to to process object names in each available language (for example the Short name of an object in French, English, etc.).
To activate this option:
1. From the HOPEX desktop menu, select Tools > Options.
2. Select Data Exchange > Import/Export Synchronization > Tools/Third Party Formats.
3. Select the option EXCEL Import/Export : MetaAttributes Translation Availability and click OK.
Dates format
By default, dates format of files generated by Excel import/export is: yyyy/mm/dd.
To modify this format:
1. On the HOPEX desktop, click Main Menu > Settings > Options.
2. Select Data Exchange > Import/Export Synchronization > Tools/Third Party Formats.
3. In the option EXCEL Import/Excel: Dates Format , define the format and click OK.