Excel serial data writer
4.0.56 build 1023. October 23, 2019.
This data export plug-in for Advanced OPC Data Logger allows to export real-time data to Microsoft Excel, OpenOffice Calc or LibreOffice Calc.
The plug-in uses the OLE interface to connect to the office suite. Therefore something one from Microsoft Excel, OpenOffice Calc or LibreOffice Calc
should be installed on the same computer.
This module has the following features:
- Data can be written to Microsoft Excel, OpenOffice Calc or LibreOffice Calc by rows or columns;
- You may specify any start point (e.g. B6) for each data item;
- The plugin can fill data using several methods (e.g move old data using the FIFO method);
- The plugin can write several parser variables to different columns or rows at the same time;
- The plugin can automatically create new workbooks or worksheets by date/time;
- The plugin can use a template for newly created files.
Thanks to these possibilities You can:
- Watch in real time data in Microsoft Excel, OpenOffice Calc or LibreOffice Calc and present this data as tables or diagrams;
- Produce documents that are already prepared for use;
- Analyze and post-process real time using formulas.
Download | Documentation