how to edit columns in a saved spreadsheet

[Nhanna Marie]

hey,
i have a problem with the data saved as an excell spreadsheet. i used write to measurement file to save the data in an excell file. the data that is being saved is torque,shear stress and viscosity but when i open the saved spreadsheet it doesnot describe the columns as the ones i want it to eg: torque, shear stress and viscosity. each of the three columns with the data have first voltage reading writen on top as description. i guess that is like the default thing but i want the columns to have writen torque,shear stress and viscosity on top.

[RJay]

Look at the order to which you write to the excel spreadsheet.

If you have a loop to write to the spreadsheet, make sure you wire the headers before the loop.

[Dennis_Knutson]

Where are you getting the data from? If it's from the DAQ Assistant, you can just name the channels there and they will be used as column names.

[Nhanna Marie]

ok this is how the program works. when you run the program,the computer asks the time you want to run the program. then it asks for the shear rate you would want to feed in. as soon as you put in the shear rate, the information goes to tyhe daq and it sends the information to a viscometer connected to the daq. the viscometer sends information like viscosity,shear stress, etc. and comes to the computer through the daq. the labview program saves this information in an excell file. now, what i am trying to do is that the columns in the excell file, each of them has first voltage reading writen on top of them. i want the columns to have viscosity, shear rate and shear stress writen on them.

[Nhanna Marie]

i have the write to measurement command in a for loop. are you saying that i need to first connect the write to measurement file to the things where it is getting the data from and then make the for loop around it. and what are headers.

[Dennis_Knutson]

Well, what I asked you was whether you were using the DAQ Assistant where you could name the channels as shown below. Are you using an NI DAQ board and are you using the DAQ Assistant that returns dynamic data? Maybe you could post your VI so someone can see exactly how you are acquiring data and saving it.

[Nhanna Marie]

yea,
i am using the daq assistant and the daq board. the computer is connected to the daq board.  and my daq assistant looks very similar to the one shown below. i am attaching my vi so you could get an idea what i am talking about.

[Dennis_Knutson]

You are creating dynamic data from some scalar values and not just the DAQ Assistant it looks like. Try the attached VI on the data before the merge signal. You shouldn't have to do anything to the signals coming from the DAQ Assistant.

[Nhanna Marie]

the thing is that in the daq assistant , add channels i need something like torque but it doesnot have an option of torque to choose from. so i selected voltage and it created a channel under voltage named 'first reading voltage'. i renamed 'first reading voltage' to 'torque' and then ran the program. the way the excell file is saved now is that all the headers of the columns have torque writen on them. i need them to have torque, shear stress and viscosity writen on them. is there a way i can change the headers of the other two columns. or is there a way i can do this using excell. i just want the headers to be named differently when we open the saved excell file.

[Nhanna Marie]

so do i place this thing before the merge signal next to the write to measurement file.