Dialog call up (for project data):- You have opened a project.File > Export > Command group Project data > Project data > Command group External editing > Properties. Click [...] next to the Settings field in the dialog Edit externally. Select the General tab in the subsequent dialog. From the File type drop-down list, select the "Excel file (*.xlsx, *.xlsm)" entry and click [Options].
- File > Settings > User > Interfaces > External editing. Select the General tab. From the File type drop-down list, select the "Excel file (*.xlsx, *.xlsm)" entry and click [Options].
- You have opened a project.File > Export > Command group Manufacturing data > Manufacturing data > Labeling. Click [...] next to the Settings field in the dialog Export manufacturing data / output labeling. In the dialog Settings: Manufacturing data export / labeling select the File tab. From the File type drop-down list, select the "Excel file (*.xlsx, *.xlsm)" entry and click [Options].
- File > Settings > User > Interfaces > Manufacturing data export / Labeling. In the dialog Settings: Manufacturing data export / labeling select the File tab. From the File type drop-down list, select the "Excel file (*.xlsx, *.xlsm)" entry and click [Options].
Tab Master data > Command group Parts > Management. In the Parts management dialog you have opened a parts database using [Extras] > Settings. Button [Extras] > Edit properties externally > Export data. Click [...] next to the Settings field in the dialog Edit externally. Select the General tab. From the File type drop-down list, select the "Excel file (*.xlsx, *.xlsm)" entry and click [Options].
In this dialog, you can specify the settings for external editing of pages, functions, connections or parts data / for labeling output in Excel.
Overview of the main dialog elements:
Include column header in output:
Use this drop-down list to specify which format elements are to be included in the export as column headers. The following entries are available:
- No: No format elements are output.
- Only property name: Only the property name, for example "DT (full)" is output.
- Complete: The relation is placed in front of the property name, for example "Cables / DT (full)".
Calculate formulas after the export:
Activate this check box to automatically calculate the formulas from the Excel template as soon as the file is generated. You do not have to open or save the generated Excel files yourself anymore.
Note:
You can only activate the Calculate formulas after the export check box if Microsoft Excel is installed and an Excel template is also used.
See also