LabVIEW

cancel
Showing results for 
Search instead for 
Did you mean: 

How to put a title row in the recorded 2D array excel file?

I am getting 2D array from labview. This file is saved to Excel File. However, I am trying to put a title row such as A, B, C, D (A is for 1st column, B is for 2nd column, C is for 3rd column and D is for 4th column) My recorded 2D data should start form the 2nd row. This data has also 4 columns which need to be aligned with the title row. Do you have any idea how I can perform this operation?
0 Kudos
Message 1 of 6
(3,345 Views)
before you write you data to the file use write characters to file.vi , use tabs between your column headers, use the concatenate strings to build up your header string , dont forget to use the end of line constant on the end of your string otherwise your 1st line of data will be on the same row as yoru header
Message 2 of 6
(3,345 Views)
Dan,

This header row is still giving me a headache. I attached the screenshot of the part I am working on. I did all you suggested to me to put a header file. The header file is in the same cell with the 1st data:( Can you take a look the file I sent you? Is something wrong with that?
0 Kudos
Message 3 of 6
(3,345 Views)
You didn't do all the things that Dan said to do. You need the tab character between your column names and you need an EOL as the last character. Redo your concantanate string so that there's a tab character after A, one after B, one after C, and EOL after D.
0 Kudos
Message 4 of 6
(3,345 Views)
You still need to add tabs and an EOL.
'Convert EOL' does not insert an EOL.
See screenshot for a couple of basic ways.
=====================================================
Fading out. " ... J. Arthur Rank on gong."
0 Kudos
Message 5 of 6
(3,345 Views)
Thanks Donald and Dennis,

Great help. It works fine now.
0 Kudos
Message 6 of 6
(3,345 Views)