ni.com is currently undergoing scheduled maintenance.

Some services may be unavailable at this time. Please contact us for help or try again later.

Instrument Control (GPIB, Serial, VISA, IVI)

cancel
Showing results for 
Search instead for 
Did you mean: 

how to write a variable sized 3d array to spreadsheet

i am challenged with figuring out how to write a spreadsheet file from a 3d array that will change in size depending on the number of channels scanned. it will vary from 1 to 60 channels selected.
0 Kudos
Message 1 of 3
(3,346 Views)
Make multiple calls to the Write to Spreadsheet File.vi in a For Loop, wiring your 3D array into the left-hand side of the loop, using auto-indexing. If you ensure that a different filename is used in each loop iteration by using the iteration counter to append a number to a base filename, you will end up with Z datafiles, each representing one slice of your X by Y by Z array.
0 Kudos
Message 2 of 3
(3,346 Views)
hi blimpie,
i confess i have only attended the basic course thus far and your solution while intersting seems a little over my brain presently. i am wondering if you would be so kind as to give me an example of your solution. i thank you for your help.
0 Kudos
Message 3 of 3
(3,346 Views)