Re : Write Continuous Analog Strain Inputs to Spreadsheet with Headers

[martiaa3]

I am using a cDAQ-9178 chassis with an NI 9235 strain gauge model to collect analog strain inputs from 3 gauges. I currently have a program (attached as Finite_Strain.vi) that collects this data and writes to a spreadsheet. I would like to use continuous sampling instead so that I can see my strain-time curve develop as I run my tests. I wrote a program that does this (attached as Continuous_Strain.vi) but I am having trouble writing the data to a spreadsheet. I am currently using the "Export Waveforms to Spreadsheet File.vi" function as opposed to the "Write to Spreadsheet File.vi" function to write my data to a spreadsheet since this allows me to have data headers and a time column. 

My problem is storing all the data from my loop. How do I build an array of all this data outside the loop and write to spreadsheet maintaining column headers?

Any help with this issue is greatly appreciated. Thank you,

Alberto M.

[ben64 · Accepted solution]

You can do this.

Ben64

[martiaa3]

What's the function you have between the Equal to 0? function and the Append to File terminal of the Export Waveforms to Spreadsheet File function? I can't open that image since I have an earlier version of LabVIEW.

[ben64]

Its invert from the boolean palette.
Ben64

[ben64]

---

ben64 a écrit :
Its invert from the boolean palette.
Ben64

---

The name of the function is "Not" not "Invert".

Ben64

[Bob_Schor · Accepted solution]

This is exactly the same thing Ben did, but I like to use this formulation because it reminds me that I'm doing something for the First Line.  You do not want to "Append to file" on the First Line (I named the Constant to remind me what it is for) but do want to write the Header for the First Line.

Bob (sorry for the broken wires) Schor

[martiaa3]

Bob and Ben, thank you for your solutions. This works great! I appreciate the help.