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!

[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.

[kstater]

Thanks for the help!

[Thermocoupler]

Hello, I'm having a similar problem.

I'm using 2-NI9211, interfaced with 2-NI USB-9162 modules measuring 8 thermocouple temperatures.

But I've been trying for quite sometime to wrap my head around exporting the data to excel or at least storing it to a .csv file.

Could someone please help point me in the right direction? Thank you

[Dennis_Knutson]

There are several ways if you just want a csv file. The Write to Spreadsheet and Write to Measurement file functions will both do it. There are examples of both. It would help if you posted the code that you have written so that someone could see what your exact problem is. Include one of the files you have generated.

[kvitf]

Hi, can help me solve the programing()Block diagram) of cRio-9025 with thermocouple NI 9211. For data acquisition.
I am using thermocouple type K.

Best regards

[Dennis_Knutson]

Your question has nothing to do with this thread - exporting data. Please start a new thread with details on the exact problem you are having. Attach the code you have for the most help.

[RavensFan]

Why did you post a completely unrelated question in a 4 1/2 year old thread?

Start a new message thread.  And make sure you put some details into it.  Right now you aren't even asking a question or providing information on where your problem is.  In that new message thread, attach your VI so people can see what you've done so far.