Task:
I have a piece of equipment that transmits serial data to a terminal program. Can the data be sent directly to Excel?
Requirements:
It is assumed that:
You’ve prepared parser items for export.
For this tutorial, all items were prepared in the previous part.
Also, you could look at some other examples of data parsing(different parser types).
Solution:
All parser items are now ready for export to an Excel spreadsheet. Please, open the configuration window of the “Local database” plugin (fig.1 and 2).
Fig.1. Local Database plugin.
Fig.2. Excel export. Selecting a database.
All other options are optional. On the second “Data formats” page, you can specify a representation of your data. Because all our variables have the “string” data type, it is unnecessary to change format settings.
On the next “Columns order” page, you can specify how variables will be exported to a spreadsheet. Suppose you do not specify a column’s order number. In that case, the program will write all variables in the following order: internal variables (FULL_DATA_PACKET, DATA_PACKET, and DATE_TIME_STAMP), parser variables, in the order, as you’ve specified in the parser configuration.