1D arrays to excel sheet

[vivek_sony]

I am having 3 1-D arrays from 3 different connector and want to arrange the three 1D arrays next to each other in excel sheet. Any suggestions.

[RManion]

Hello,

In order to save three columns into a spreadsheet file, I would recommend using two VIs that come in LabVIEW.

1) Create a 2 dimensional array by using build array and wiring in your three inputs. The "Build Array" Can be found under the 'Array' sub palette.

2) After creating a 2 dimensional array, you can write this to a spreadsheet file using the "Write to Spreadsheet file" VI. This VI can be found on the FILE I/O palette.

Additionally, National Instruments has a large amount of example programs that might be helpful. Here's a link to an example that might be close to your application: Saving to a Spreadsheet File


Hope this helps,

Robert Manion
Applications Engineering
National Instruments

[BruceAmmons]

One minor additional suggestion: You may need to use an array transpose on the 2D array before writing it to a spreadsheet file.

Bruce

[vivek_sony]

Thanks!