Exporting and Importing OPC DA Logging Configurations as Excel Spreadsheets
The Logger Administrator's data table, known as the Trends Grid, functions similarly to an Excel spreadsheet and can be copied and pasted into Excel for editing purposes.
Exporting the Trends Grid to Excel
Microsoft Excel offers functionality not available in the trends grid, such as conditional formatting or print optimization. Some users may be more comfortable using Excel as opposed to the Trends Grid.
Select all the tags in the grid by selecting the cell in the topmost and leftmost corner of the grid. The traditional click and drag technique can be used to select all of the tags as well.
Copy and paste into the Microsoft Excel Spreadsheet.
Notice a header row is created in Excel that did not exist in the trends grid. The header row must be copied and pasted when Exporting the spreadsheet back into excel.
Importing an Excel spreadsheet into the Trends Grid
After the appropriate edits have been made to the spreadsheet, import the spreadsheet into the trends grid within the Logger.
Create a header row directly above the first tag row that has column descriptions identical to the trends grid.
Make sure the header row is written exactly as shown below:
Copy only cells that are being exported into the Trends Grid
Do not copy the entire spreadsheet or any blank cells, doing so results in errors when cells are pasted into the Trends Grid.
When pasting the spreadsheet, right-click and select 'Paste New Trends'
Do not use the hotkey Ctrl-V or select the usual paste option, doing so replaces the copied cells with the existing cells.