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 the Export Spreadsheet panel, you can:
Choose Table → Export → Spreadsheet in the Project Table 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.
The Export Spreadsheet panel is a standard file selector, with an Options button that displays or hides the options. The options are described below.
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.
This option menu allows you to select the set of properties that are exported. Choices are either all properties (All), the visible proeprties (Shown), or properties that you select (Selected). The entry title is always in the first column in the exported file.
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.
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.
|