LabVIEW

cancel
Showing results for 
Search instead for 
Did you mean: 

Spreadsheet Outputs from Labview 6.1

I am trying to produce a spreadsheet output for experimental data. How do I produce headers for columns of a spreadsheet table.

I have tried using sequencing boxes but have come into difficulty putting strings and numerical values into the same array.

Thank You.
0 Kudos
Message 1 of 4
(2,736 Views)
Hi Neil,

you can`t put strings and numbers in the same array. An Array accepts only one data type, in this case either numbers OR strings.

What you can do is write the strings (tab delimited, with control/return at the end) into the required file before calling the "write to spreadsheet" VI. It`s important to then wire the VI so that it Appends to the existing file, otherwise it`ll be overwritten.

Then you should have your spreadsheet file with headers.

Shane.
Using LV 6.1 and 8.2.1 on W2k (SP4) and WXP (SP2)
0 Kudos
Message 2 of 4
(2,736 Views)
Thanks that seems to have done the trick.
I am from the UK but have a summer job in Austria so am having to learn LabView in German. :s
0 Kudos
Message 3 of 4
(2,736 Views)
I`m familiar with the situation. I`m based in Switzerland (the german speaking part) and to be quite honest, I`ve forgotten how a number of things are called in English. If you can, when you learn something new in German, try looking up the word in English too..... For a summer job it shouldn`t be too bad, but my English is getting worse all the time 😞

Shane
Using LV 6.1 and 8.2.1 on W2k (SP4) and WXP (SP2)
0 Kudos
Message 4 of 4
(2,736 Views)