LabVIEW

cancel
Showing results for 
Search instead for 
Did you mean: 

add header to spreadsheet file

What is the simplest way to add a header to the spreadsheet file?
Peter Liu
0 Kudos
Message 1 of 3
(3,350 Views)

If you are using strings and the write string to file function you can use the concatenate strings function and use tabs between each of your columns and an end of line constant to start a new row.  THis is probably the easiest.  All the strings functions are under the strings palette.  Hope this helps.

 

 

BJD1613

Lead Test Tools Development Engineer

Philips Respironics

Certified LV Architect / Instructor
0 Kudos
Message 2 of 3
(3,345 Views)
If you are not using the Write Strings to File, then just write the header when you first open the file.  Use either tabs or commas to match how the data is formatted.  I like to use a string constant with \ codes displayed to simplify the header to only one element (i.e. "Timestamp\tFrequency\tTemperature\tTorque\r\n").
Michael Munroe, CLD, CTD, MCP
Automate 1M+ VI Search, Sort and Edit operations with Property Inspector 5.1, now with a new Interactive Window Manager!
Now supports full project automation using one-click custom macros or CLI.
0 Kudos
Message 3 of 3
(3,340 Views)