Can I enter text into spreadsheet with Write to Spreadsheet.vi

[programmindragon]

I'm trying to use the Write to Spreadsheet.vi and I'm entering numerical values. I want to add a text header before I enter the numerical values. Is there and easy way to do this?

[falkpl]

First use the "write characters to file" vi passing it your header string, then send the file out wire from this vi to the file in wire of the "write to spreadsheet file" vi. Make sure you set the append to file of the "write to spreadsheet" vi to true otherwise you will receive a second file dialogue, also concatenate a character return or two to your header string so the header is not in the same index as the first data point. Good luck and sorry I didn't have ime to attach the code.

Paul

[tst]

For some reason, these VIs don't accept strings as input. If you double click them and look at their block diagram, you will see instructions for modifying them. If you do, you will have to convert your numbers to strings and then back to numbers when you read from the file. Also, make sure you do not overwrite the original file.

[DD]

Try using the Write Characters to File vi. Right-click on your input string
and set '\' Codes Display formatting. Use a tab (\t) between your headers.

"programmindragon" <x@no.email> wrote in message
news:196304@exchange.ni.com...
> I'm trying to use the Write to Spreadsheet.vi and I'm entering numerical
> values. I want to add a text header before I enter the numerical values.
> Is there and easy way to do this?