Multiple channels dynamic data to array, then save to Excel

[Pinca]

Hello,

I acquire data from multiple channels (4-5) and I would like to collect samples at low rates (10 Hz for 3 minutes max). For various reasons I use Dynamic Data type, although I know, that it is not the best way (some say that it is an evil data type 🙂 ). I would also like to save acquired data to a file (the best option would be excel data file). 

If I acquire data 10 times per second, it is quite slow to save it to excel (it is the slowest option of all data types). So I would like to fill an array or a matrix with acquired data and then write it to excel file (I use Write to measurement file). But I do not know how to do it - if I convert DDT to DBL, build an array and connect it to shift register, it works but I lose the column names information and I lose time. If I connect to build array one DDT and then from SHIFT register another one, it returns 1D array of DDT. I would like to have 2D DDT, which collects all the information from the loop.  Would there be any suggestion how to solve it?

I am sure that it would be easier to solve my problem with DBL data type but I also use Select Signals VI which is the VI I am not able to substitute at this moment. 

Have a nice day

Pinca

[Bob_Schor · Accepted solution]

I'm not sure if there's a question here, or what.  To do what you say you want to do, acquire data from 4-5 channels at low rates (10 Hz for 3 minutes) and save the data to an Excel file (I assume you really mean Excel, namely a file with the extension .xls or .xlsx) is really a very easy thing to do in LabVIEW, especially if you do not use:

• DAQ Assistant
• Dynamic Data
• Write to Measurement File.

Indeed, you seem to realize this, but I guess you are going to "do it the hard way", anyway.

Good luck.

Bob Schor

[Dennis_Knutson]

You need to take one or more of the free tutorials and read the LabVIEW help. A build array can create a 2D array if you configure it correctly and you can substitute the Select Signals easily.