Reports can be exported to a prepared MS Excel template. This template can contain some pre-filled texts, user formatting, company logo, etc., and can be saved in different file formats (.xls, .xlsx, .xlsm, .xlsb, .xlt, .xltx, .xltm, .ods).
After adding a new Excel tab using the
button, the user can load the pre-defined template by clicking on the button and selecting the template file.
button can be used to clear the path to the template which is shown on the left when the template is loaded.
The main table in the Excel tab displays all measurement features and validation values available from the current measurement definition (Feature column) and the target cells (Cell column) which will be filled with the appropriate value in the Excel template. It can list cells in the Excel format, e.g.: “A1, B3, G7” or the range of cells “A5:C8”. Alternatively the user can set the combination of the two mentioned “A5:C8, B9:B12”. Images are automatically sized into the target cell. Timestamps are inserted into the cell respecting the time format defined by the user.
When exporting the Excel template (either from the Measurement Explorer or Measurement Sequencer - Run), a copy of the .xlsx file is opened from the disk, the worksheet is named according to the report name and filled in. When more reports are exported, more worksheets are appended. The system recognizes the opened Excel document and automatically appends new worksheets to it. Saving any exported Excel document is up to the user as the saving is not managed by NIS-Elements.