06-24-2019 03:45 AM
Hi all,
I am using LabVIEW to acquire data from sensors (temperature, humidity, pressure etc) using Modbus protocol (rs-485). My data is divided into input and holding register depending on the type of sensor output. I have developed a LabVIEW VI which correctly obtain the sensor values (in terms of input and holding registers). Now I am stuck with how to save the data such that I get one excel file with the header as sensor1, sensor 2 ... (or with sensor ID) and my rows as data acquired in continues time manner? Any help on how to develop a VI, please see the attached picture where I need to save my data from points described by a red circle in the attached picture.
06-24-2019 03:49 AM - edited 06-24-2019 03:51 AM
Hi satoo,
how to save the data such that I get one excel file with the header as sensor1, sensor 2 ...
The term "excel file" is quite undefined, I guess you are talking about a spreadsheet file aka delimited text file aka CSV…
Write the header line before your loop into the file using WriteToSpreadsheet File.
Write the data to the same file in the loop using the same function. Read the help for the function to learn hwo to append data to existing files…
06-24-2019 03:55 AM
Hi,
Thanks for a quick reply.
thanks for correcting me, I mean exactly the spreadsheet like
Do you think 'WriteToSpreadsheet File' will serve my purpose in the present case or 'WriteToMeasurementFile' option in LabVIEW?
06-24-2019 04:09 AM