Read excel sheet

Dashboard
1

I placed GPS position data in an excel spreadsheet (.xls) and I want to restore that data for reconstruction of my route (incl. speed and heading) over the water in one day. I saved that data every 10 minutes and that works fine. When I want to read thsi data I use the next function in a function node.

input=msg.payload.A2.w;
global.set ("log_datum_2",input );
msg.payload=input;
return msg;

This works fine too, but...when i want to restore all data I have to use a lot of function nodes, so I want to set (in this case) A2 as a variable. I tried several things without succes.

Someone a tip?

thanks in advantage

2

Are you storing it in Excel for a particular reason? If not then it is generally better to store it in a database such as influxdb which is explicitly designed for saving time series data.

3

This topic was automatically closed 30 days after the last reply. New replies are no longer allowed.