Export Spreadsheet Panel

The Export Spreadsheet panel allows you to export (save) rows and columns from the Project Table to a file. This data can be read into a spreadsheet such as Excel.

To open this panel, do one of the following:

  • in the Project Table panel, choose Data → Export → Spreadsheet
  • click the Tasks button and browse to Project Table and Project Operations → Export to Spreadsheet
  • Using
  • Features
  • Additional Resources

Using the Export Spreadsheet Panel

To export data from the project table to a spreadsheet file, first navigate to the directory and select the file or enter the file name. Click Options to select the class of entries you want to use to export data from, the class of properties you want to export, and the delimiter to use in the file, and click OK. Click Export to complete the operation.

Export Spreadsheet Panel Features

The Export Spreadsheet panel is a standard file selector, with an Options button that displays or hides the options. The options are described below.

Entries option menu

This option menu allows you to select the entries from which data will be exported. Choices are: all entries, the entries that are displayed, the selected entries, or entries that are included in the Workspace.

Properties option menu

This option menu allows you to select the set of properties that are exported. Choices are either all properties (All), the visible properties (Shown), or properties that you select (Selected). The entry title is always in the first column in the exported file.

Select button

Click this button to select the properties to export. Opens a standard property selection dialog box, so you can choose the properties. The number of properties selected is reported to the right of this button. The property selection is stored both as a project preference and a user preference; it is initially set to the shown properties.

Only available when you choose Selected from the Properties option menu.

Delimiter option menu and text box

This control sets the column separator in the output file. Commonly used styles are comma for a comma-separated value (.csv) file or tab for a tab-delimited file. Other choices can be selected by choosing other and entering a delimiter into the text box.

Precision options

Specify the precision to use in the CSV file for writing real numbers.

  • Displayed—Write real data to the CSV file with the precision used in the Project Table, i.e. exactly as displayed. This is the default behavior of spreadsheet programs such as Excel, as well as Maestro.

    Note: If the number is small and stored in fixed-point format, it may be truncated to zero for display, and is therefore written out as zero. If this is not what you want, you should either use the Full option, or use exponential notation to display the number (Data → Edit Properties → Decimal Places, choose property, select Use E notation).

  • Full—Write real data to the CSV file with the full precision as stored in the project. No truncation of the data is done.

Note: When you read the file into a spreadsheet application, you may also need to set the display precision in the spreadsheet to see all the figures written to the file.

Include 2D image option

Include the 2D image for each structure when exporting to an Excel spreadsheet (.xlsx). Only available when this format is selected.

Related Topics