LabVIEW

cancel
Showing results for 
Search instead for 
Did you mean: 

splitting 1D data into multiple columns in excel

I have a Labview program that reads two gpib dmm's and writes the data to a spreadsheet. Each reading is 1 Sec. I reached the maximum limit in excel of 65536 rows.

Can anyone give me some pointers on how to split subsequent data into additional columns so I can get all the data in one spreadsheet?

Thanks.
0 Kudos
Message 1 of 4
(2,758 Views)
Try the Reshape Array function before writing the data to the file.

Mike...

PS: Ever been to Corning, New York?

Certified Professional Instructor
Certified LabVIEW Architect
LabVIEW Champion

"... after all, He's not a tame lion..."

For help with grief and grieving.
Message 2 of 4
(2,758 Views)
Mike,

I tried the reshape array function, with the constant set at 6 for six columns. I must be doing something wrong, because the program still truncated the data at 65536 and the other four columns wer filled with zeros.

Would you be able to give me some more specific details?

Thanks,

Jared
0 Kudos
Message 3 of 4
(2,758 Views)
Attached is an example showing how to use it...

Mike...

Certified Professional Instructor
Certified LabVIEW Architect
LabVIEW Champion

"... after all, He's not a tame lion..."

For help with grief and grieving.
Message 4 of 4
(2,756 Views)