LabVIEW

cancel
Showing results for 
Search instead for 
Did you mean: 

writing to excel file from DAQ assistant

Hi,

 

I'm currently using the National Instruments USB-6211 Data Acquisition card to acquire 3 signals simultaneously, one of which is temperature.  I am reading 1000 samples each second and it is working fine, but I'm looking to output the temperature to an excel spreadsheet once every minute with just one value being entered each time and not 1000.  Is there a way to achieve this?

 

Thanks!

0 Kudos
Message 1 of 3
(4,414 Views)
Sure. The simplest way is to use one of the built-in functions (Write Measurement File/Write to Spreadsheet File) which will create a text file that Excel can easily import. For the timing, you could use the Elapsed Time function and wire the Time Has Elapsed output to a case statement. Inside the case statement, either extract a single value or perform a mean of each channel and then write that.
Message 2 of 3
(4,407 Views)
Thanks a million, worked perfectly
0 Kudos
Message 3 of 3
(4,387 Views)