exporting labview data excel

[kstater]

Hello. I have data going from labview to excel and it pulls up great. I have 8 different thermocouples. What I've been trying to figure out is how to label the columns in excel so that it lists the thermocouples and doesn't just give a generic label like "formula" for each 8 instances. For example, I want it to say Blue, Red, Green, etc.    I'm very new to labview and have looked at posts and examples of how to do it but it's still confusing to me. I was hoping someone could take a quick look at the snapshots I've posted and let me know what to do or provide a fix. Thanks!
 
 


Quick Temperatures_Bruce.vi:
http://forums.ni.com/attachments/ni/170/348853/1/Quick Temperatures_Bruce.vi


Quick Temp.doc:
http://forums.ni.com/attachments/ni/170/348853/2/Quick Temp.doc


Test.xls:
http://forums.ni.com/attachments/ni/170/348853/3/Test.xls

[Dennis Knutson]

I spent a lot of time just cleaning the absolutely horrible wiring of your VI. I'm sorry but neatness really does count. I replaced all of those formula express VIs with Expression Nodes and used a couple of Write to Spreadsheet File functions instead of the Write to Measurement File. Then I realized that you had a very old version of LabVIEW - one I cannot save to. Attached is the image. It should give you an idea of what your VI could look like if you spent a little time.
In 7.0, in order to get Write to Spreadsheet File to save a string array, you have to follow the directions on the block diagram to modify it and then save as a new name and in a new location. You could also write the header with the Write to File. The whole idea is to write the header first as string data and then append the numeric data to the same file.


Cleaned Up.PNG:
http://forums.ni.com/attachments/ni/170/348862/1/Cleaned Up.PNG