From 04:00 PM CDT – 08:00 PM CDT (09:00 PM UTC – 01:00 AM UTC) Tuesday, April 16, ni.com will undergo system upgrades that may result in temporary service interruption.

We appreciate your patience as we improve our online experience.

LabVIEW

cancel
Showing results for 
Search instead for 
Did you mean: 

Automatic data log

How do I get my programme to automatically log the data either to a text file or an excel file?

Thanks!

0 Kudos
Message 1 of 5
(2,548 Views)

what kind of data? how frequent do you need to update the file? how many parameters and how many lines of data you want to write at once?

0 Kudos
Message 2 of 5
(2,528 Views)

If your data is already in an array, you can use the 'Write to Spreadsheet File' function.

You can specify the delimiter as well such as tab-delimited text or comma separated values (csv).

Cory K
0 Kudos
Message 3 of 5
(2,513 Views)

Hi, Thanks for your replies. I've had a look and there doesn't appear to be a "write to spreadsheet file" option anywhere in the toolbars. When I constructed the block diagram, should I have included it in that?

 

The data I'm trying to collect is temperature (degrees Celsius) and pH, once a minute, therefore 2 parameters but they are in one line (as collected from the same equipment).

 

Thanks!

0 Kudos
Message 4 of 5
(2,488 Views)

Write to Spreadsheet File is a VI in the Programming » File I/O palette.  You will need to insert it in your program whenever you need to write to file.  This will write an array data structure into a tab-separated text file (you can specify other separators).  To write to an actual Excel file, you will need the Report Generation Toolkit, or you can write your own code using the ActiveX interface.

 

However, if I interpret your question correctly, that is not what you are looking for.  Do you want to click on a control and export that data to a file?  If that is the case, you will need to program that behavior yourself, since LabVIEW does not support it (SignalExpress does).  If you would really like to see this as a feature, I would recommend you ask for it at the LabVIEW Idea Exchange.

 

Let us know if you need more information or help.

Message 5 of 5
(2,478 Views)