display array columnwise

[sujani]

hi,
I have a vi that creates a new 2D array in the end of each loop and stores each array in a separate spreadsheet file.I would like to append everything to the same file-but the problem is that labview adds new rows to the array-i want new columns to be added to the array.any suggestions?(basically i am trying to chunk up a big data file into smaller chunks after viewing the waveform in labview-attached:vi)

[shoneill]

Let LabVIEW write the rows. Just transpose the 2-D array when you load it, and then the rows will be columns and vise versa.

If you want the data to be readable as columns as ASCII or in Excel, write the rows as above, but when you`re finished, read in the entire file, transpose the values and re-write the file. Now you`ll have the desired structure.

Another option is to store the 2-d arrays in memory until you have all your required values and then format as required and write after the VI is finished.

You can`t automatically write columns without extreme disk access (and very slow write times).

Shane.