Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Q:     How can I export table data to CSV or Excel File Format. 

A:     Most data tables include a CSV button that will export all table dataand an Excel button. The CSV button exports the data table to the CSV file format while the Excel exports the data table to an Excel file making it the better choice if you intend to edit or manipulate the data in Excel. The exported data will include “All” entries regardless of number selected in the Show entries drop-down list for the table.

For example:

1. Click the CSV button (examples below) and you button or the Excel button.

Image Added

2. You will be prompted for the output format which can be an Excel file or a CSV file. If you click Save File, locate the file in your Downloads folder.

Image Removed

2. Packages Dashboard CSV button:

Image Removed

3. Spool Checker CSV button:

Image Removed

4. Part Properties CSV button and Copy option which removes quotes:

Image Removed

5. If you use a column header filter like Status, the output will be limited to the filtered list.

Image Removed

.

3. Open with - To Open with, select Open with radio button with Excel selected regardless of which button was clicked. If the CSV button was clicked in STRATUS, the file will open in the CSV file format. If the Excel button was clicked in STRATUS, the file will open in the Excel file format.

4. Save File -To save the file, click the Save File radio button. If the CSV button was clicked in STRATUS, the file will save in the CSV file format. If the Excel button was clicked in STRATUS, the file will save in the Excel file format.

Image Added