Writing data to excel in multiple columns

[Jheffy]

Hi,

I have 9 arrays of values that I concatenate into one array, which I then send through a formula node. I split the resulting array back into 9 arrays, which I would like to write to a spreadsheet file, such that each array is one column. I also have a "time" column which I want write as the first column, followed by the 9 columns (the arrays that went through the formula node).

Right now all I get is one long column.
Any suggestions?

[Darren]

You need to wire each of your data arrays (PT100 1 through 9) as separate inputs into a Build Array function, with the Time array as the first input, for a total of 10 inputs.  Make sure the "Concatenate Inputs" option on the Build Array is not selected.  Then wire the resulting 2D array to the "2D data" input of the Write to Spreadsheet File.vi.  This should give you the data in the format you need.

You can learn more about constructing arrays by reading the LabVIEW Help on the Build Array function.

Good luck,

-D

[Jheffy]

Yeah, that works, thanks.
Now is there an easy way to insert column headers at the top of the columns?
It seems complex because this seems to require an array built both row-by-row and column-by-column...

[Darren]

Yes, there is an easy way to insert columns or rows into your array.  Use the "Insert Into Array" function from the Array palette.  Then you can specify the row or column index at which you want to insert the new row/column.  If you want it to be at the beginning of the array (like if you want a row header or a column header), you would wire an index of zero.  Check out the LabVIEW Help for Insert Into Array for more information.

Hope this helps,

-D

[Jheffy]

Well, all right. So I played around with number-to-string to be able to insert headers as a string array, but the spreadsheet file that comes out of this mostly only shows "F" characters.

I've attached the mess.

[Darren]

If you want to see the numbers in normal format, you may want to consider using Number to Fractional String instead of Number to Hexadecimal String.  If you want to see the numbers in Hex, though, expect to see a lot of 'F's.  🙂

-D

[Marc_A]

What I do is simply create a string with column headers separated by tabs (\t), then write this to the file with Write Characters to file.vi.  Then you write your spreadsheet to the same file and wire true to the Append to File input.

[Jheffy]

Thanks, it's all good now.

[ahmadainnn]

I am aquiring about 4 types of data continuously and I need to put each in a seperate column. What should I do?

(Building these data in 2D array is not an efficient way, is there any other way)