how to edit columns in a saved spreadsheet

[Dennis_Knutson]

How are are you trying to add this information? Are you using the comment input of the Write to Measurement File? I believe comments are added to a column with the data. If you want the information in the header, I don't think you can use the Write to Measurement file as is. The properties page has a 'File Description' field. Unfortunately, this is not an input to the Express VI that you can wire a string to. The good news is tha it can be modified to do this. Right click on the Write to Measurement File and select Open Front Panel. this will convert the Express VI to a regular VI. Look on the block diagram for a string constant called 'description'. Right click on this and select Change to Control. Go to the front panel and connect this new control to somewhere on the connector pane. Save this VI. You know have a modified subVI that works exactly like the function you had before except you can no longer select properties to change something.

The alternative is to skip the Write to Measurement File altogether and use some of the low level File I/O functions.

[Nhanna Marie]

hey,
i have attached my spreedsheet. i just want to input the user name, sample name and a short sample description that the user wants to have in the spreedsheet. I want use write to measurement file for this. Could you please help me with this, like is there no way we can put in this information using write to measurement file. the spreedsheet has the operator name as txguest, is there a way i can edit that to be the name of the operator.
With the 'Front panel' i did everything and saw ' description' but couldnt find Change to Control. there were three descriptions i tried all of them.

thanking you
summit

[Dennis_Knutson]

Its on the block diagram though it's hidden a bit by the label of another control.

[Nhanna Marie]

hey i did the change to control to the string contant and then i copied and pasted the sub vi to my original vi. is that what i was supposed to do?
and then i tried connecting the sub vi to the write to measurement file. it gives an error saying ' you have connected two terminals of different types'. could you please tell me how i can fix this. pleeeeaasee.
thank you so much

i have attached my vi  to  show  you  what  i  did

[Dennis_Knutson]

No, no, no, no! If you had done it correctly, you would have had a new input on the modified VI called 'description'. This is where you should wire the string control. One thing you have to realize is that each VI is a separate file. When you attach the top level VI, it does not include the subVIs you use. Attach the modified subVI so I can see what you did wrong.

And please, start to clean up your VI's wiring. Wiring should be done from left to right and should be done from right to left and then up and around again. That means that for proper 'style points', your Write Measurement File should be on the far right side of the diagram. This makes it clear that the file write is done after all of the other code on the diagram.

Message Edited by Dennis Knutson on 07-20-2007 11:24 AM

[Nhanna Marie]

the 'description' input, will it be  in the 'write to measurement file' in the front panel. like the thing is , i dont know if that was supposed to happen or not, but my write measurement file change color from blue to yellow after i did change to control.

[Dennis_Knutson]

If you did it correctly, the 'description' input will be visible on the block diagram of the VI where you call it. If it's not there, then you either didn't change the constant to a control or if you did, you didn't wire the control to the connector pane.

[Nhanna Marie]

this is what i did with the change to control.

[Nhanna Marie]

wait.......how do i wire the control to the connector plane... coz this is the step that i have not done...

[Dennis_Knutson]

There are extensive instructions in the on-line help. Search for the 'connector pane' topic. Briefly, you go to the front panel and right click on the icon that is in the upper right corner of the screen and select Show Connector. You will see a pattern of little boxes. The ones that are colored, are already connected to inputs and outputs. As you move over the connector pane, you should see the cursor change to the wiring tool. Pick a white box (preferably one in the left half of the connector pane) and click on it. Next, click on the new control ('Description') that you made. The box should change to a red color. Save the subVI.