Microsoft Excel Export Options dialog box

Access:

In a drawing,

  • Right-click a parts list and select Edit Parts List. In the Edit Parts List dialog box, click Export, and then in the Export Parts List dialog box, click Options.
  • Right-click a general table or a configuration table and select Edit. In the Edit Table dialog box, click Export, and then in the Export Table dialog box, click Options.

Selects columns and specifies formatting preferences for data to export to an Excel spreadsheet.

Exported columns

Lists the columns in the parts list or table. All are selected by default. Clear the check boxes beside columns you do not want to export.

Format

Specifies Excel formatting options to apply to the data. Select a check box to apply the preference or clear it to ignore the format rule. In most cases, you can later change the format using Excel commands.

Apply cell formatting specifies that the data to format according to the formatting set in the Excel cells.

Force cell to Text formats all data as text, regardless of its content.

Autofit column width specifies if the column resizes to accommodate the amount of data.

Include title reserves a row for the table. Not available if the parts list or table has no title.

Starting cell specifies the row and column for the starting cell. The default is Row 2, Column B.

Template browses to an Excel spreadsheet that you want to use as a template.