Write multiple measurements to file

[dspRy]

I'm currently trying to use Lab View to record readings from a multimeter to a file. The current way I'm doing this is having 5 different files that are written to so I would like to try and send them all to one excel spread sheet, one column for each type of reading. Is this possible with write to measurement? 

[crossrulz]

The problem I am seeing is that you are taking different types of measurements with the same DMM.  You therefore have to mke changes between measurements to do what you want.  Are you currently doing that?

[dspRy]

Yes, currently. The vi I included has been made more functional but I'm still having issues getting all of the measurements into the same excel sheet. The switching of some things around before the next measurement could also be fixed as I have acess to a 6509 and matrix card.

[crossrulz]

In that case, use a FOR loop to go through all of the measurements and use an autoindexing tunnel for the measurement.  This will give you and array of measurements that you can then write to the file as a row, giving each measurement its own column.

[dspRy]

As in one loop per set of measurements? 

[Bob_Schor]

Yes, that's exactly what he means.  I've never used Write to Measurement File, but I've done a lot of writing to (and reading from) .xlsx Workbooks using the Report Generation Toolkit, which is included with base LabVIEW starting with LabVIEW 2014 (and you seem to be using LabVIEW 2013, where it is an add-on Toolkit).

If you want to try the Excel option in your code, I recommend writing a tiny Demo program that, say, creates a 1D array of 5 random numbers (a sample from 5 channels) and does maybe 10 "writes" before stopping.  Look at what you get, and adjust your code accordingly.

Bob Schor

[dspRy]

Ok, I'm seeing the picture here.. Something similar to this?

[crossrulz]

I was thinking something more like this.  You should also do the full setup for the test inside of the case structure.

[dspRy]

Interesting, I added names to the columns and now it will only output one row of data instead of appending the file.

[dspRy]

Nevermind, it works. I'm putting in the process now to change the configuration.