Spreadsheets in LabView

[arthur51189]

I have a couple of issues regarding spreadsheets.

When i save the the data to Excel i want to label the columns, I used concatenate string and then the Write Characters to File.vi but when i open the spreadsheet i don't see the label for the columns.My other issuse is the following: I have 3 seperate excel files for Magnitude, Phase and Frequency. Is there anyway i could have combined all 3 of those to 1 excel spreadsheet in 3 seperate columns?

Thank you

[RavensFan]

Please attach some code.  Also examples of your files.

How are you saving data to Excel?  Write characters to file, and write or read spreadsheet file, do not work with .xls files.  They just create text files.  In the case of Read (Write) spreadsheet file, it writes arrays to a text file in a format that allows Excel to be able to open and import it, but they do not create .xls files which is a proprietary Microsoft binary file format.

[Dennis_Knutson]

duplicate post