This functionality is only available for certain module packages. Info / Copyright

Dialog Settings: Excel export

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

ClosedDialog call-up (for labeling data):
  • 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].

ClosedDialog call up (for parts data):

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

See also

Excel Templates for External Editing