Generate an Excel report from Table data

You can export the data from a Table to Microsoft Excel. When you export the data, AVEVA Process Simulation generates an .xlsx file, which you can then open in Excel. The .xlsx file has a single worksheet named Table Data that includes all information from the Table in AVEVA Process Simulation. Currently, the data values are static. If you make changes to the simulation, you must regenerate the .xlsx file to view the latest data.

Generate an Excel report for a Table

1. Do one of the following:

   • Open the Table, and then select Expand the configuration section to expand the configuration section.

   • Right-click the Table on the Canvas, and then select Full Properties.

2. (Optional) In the Report section, in the Excluded Rows box, enter the Name of any rows that you want to exclude from the Excel report. If you plan to exclude more than one row, separate the names with commas, for example, Hv, Hl, rhov, rhol.

3. In the Report section, select Generate Excel Report.

   The Save As dialog appears.

4. Browse to the location where you want to save the .xlsx file.

   By default, the .xlsx file has the same name as the Table on the Canvas.

5. (Optional) In the File name box, change the name for the file.

6. Select Save.

   AVEVA Process Simulation generates the .xlsx file and automatically opens it in Excel.