LabVIEW

cancel
Showing results for 
Search instead for 
Did you mean: 

How can I save 3 of 1D arrays into excel file neatly? VI file is attached. Thanks...

I have 3 of the 1D arrays. When I combine them, I get 1 very long column in excel. Instead I want to have three columns of shorter arrays. I attached the vi. Besides, is there any way I can write on the 1st row of the same excel file.
0 Kudos
Message 1 of 2
(2,673 Views)
There's more than one way to "combine" arrays.

Look at the BUILD ARRAY function.

If you wire three arrays to three inputs, you have a choice of outputs:
You can CONCATENATE the inputs, in which case the output is a longer 1-D array.

If you DON'T concatenate them, the output is a 2-D array, which sounds like what you want.

You will probably want to TRANSPOSE the 2-D ARRAY, as this will give you three columns of N rows. Without transposing, you get three rows of N columns.

If the original arrays are not equal length, they will be padded with zeroes.
Steve Bird
Culverson Software - Elegant software that is a pleasure to use.
Culverson.com


LinkedIn

Blog for (mostly LabVIEW) programmers: Tips And Tricks

Message 2 of 2
(2,673 Views)