Export to Microsoft Excel

The contents of all the grids can be exported to a Microsoft Excel spreadsheet with the same layout of columns and rows.

Data can also be exported to an Excel spreadsheet from a number of windows that display data in a grid, for example the Import Log window.

Note: All records in a grid are exported, not just those records currently loaded and displayed in a grid.

To export the contents of a grid to an Excel spreadsheet

1. Open the appropriate grid.

2. On the Manage Tab in AVEVA Instrumentation, click Export to Excel in the Export section.

   The Save file as window displays.

   

3. Select the location to which the Excel file is to be saved, enter the File name, and click Save.

   The export then takes place.

   The contents of a grid (except the Seed List in Designer) may be exported to a spreadsheet with an extra column which is automatically populated with a unique identifying number for each row of data.

4. To produce a spreadsheet in this format, proceed as described above, but select the Export to Excel (With Id) option, accessible by clicking the arrow next to the Export to Excel option.

5. To export to a spreadsheet from a grid in a window, click the Export to Excel button and specify the file name and location as described above.