General Excel Export - Intergraph Smart Materials - Version 2020 (10.0) - Help - Hexagon PPM

Intergraph Smart Materials Classic Help (2020)

Language
English
Product
Intergraph Smart Materials
Subproduct
Classic
Search by Category
Help
Smart Materials/Smart Reference Data Version
2020 (10.0)

You can use the Excel Export button in all Smart Materials screens to export the displayed data to an Excel file.

  1. Click the Excel Export button. The Export/Import Options window opens where you can specify how to store the data.

    The Output File field displays the name of the output file with the entire path. The name is automatically generated by the software and cannot be changed.

    In the Export Format section, you specify how the text is formatted in the file. Select Excel if you want to export the data into a semicolon separated Excel file. The other options create plain ASCII (txt) files with a tab, a space, or any other specified character as a separator. To align the columns, select the Column Align check box.

  2. Click Select in the Blocks to Write section to open the Select Blocks window.

  3. Select the Select check boxes of all screen blocks to be exported to the file and click OK.

    You can specify the records to be stored in the file in the Records to Write section.

  4. Select All Records queried to export all queried records or All Records displayed to export only the records currently displayed on the screen.

    You can also specify the fields to be stored in the file in the Fields to Write section. With All Items selected, the job exports all fields on the screen, whereas Displayed Items exports the currently displayed fields only. With the Re-Importable indicator selected, the data is exported in a format that allows re-import into Smart Materials where applicable.

  5. Click OK to start the export. The picture below shows an example file.

    For more information, see Print to File.