Lab use write spreadsheet

[Dj0626]

Thanks. 

Obviously my knowledge on this system is minimal and is a struggle for me... can you be a little more specific on wiring a "true" to the right side? 

Am I correct in using the 1D array option and connecting it where I did? 

Also, do setting revert back on the vi after a certain amount of time?

[Bob_Schor]

Something I always recommend is to write a "Test VI" to test something.  Here is one that (a) generates a 1D Array of "random data", simulating taking 100 samples of analog data at 100 Hz (so it repeats every second) and writing it to a (single) Delimited Spreadsheet file.  

There are two Shift Registers -- one carries the Error Line (so an error will probably stop the Write Delimited from running), but the other carries the "Append-after-first-write" control (you don't see, probably because I forgot to wire it, the "F" wired to the outside left of the For Loop -- it will work without wiring False because that's the default value, but it was "sloppy programming" for me to forget it!).  Notice the True wired to the end of the Shift Register -- the next (and all subsequent) loop(s), this will remain True, and you will append.  You'll end up with N rows of 100 columns.

I forgot how you are taking data.  If you are taking a single channel, you'll have a 1D array, and would wire it into the 1D input.  If you have multiple channels, it will be a 2D array, and you'll have to "run a test" to see how it writes.  You decide if rows are samples and columns are channels (the usual format), or if you want rows to be channels and the columns to be the data.  It's up to you, but you may need to transpose the 2D array (there's a helpful input in Write Delimited Spreadsheet, see the Help entry, for this).

Bob Schor