write spreadsheet help

[vmrak]

Being very new to this I am finding many of the examples to complicated to follow. Can someone give me a very simple example of the write to spreadsheet function

Just show me how to write three pieces of data to a row I would like to see a number, string, then number. Once I understand the basics I have pretty much been able to figure things out the rest of the way on my own.

thanks in advance

[MikeS81]

Hi vmrak,

if you want to write a string, you have to transform all datas to string. See the attached picture. Hope it helps.

Mike

Message Edited by MikeS81 on 05-06-2008 03:06 PM

[Jorge_Amaral]

Hello,

See the attach

[vmrak]

thank you very much guys these were exactly what I was looking for

[vmrak]

Mike my application is very similar to what you posted can you look at my vi I have attached it it was done in labview 8.2. I cant figure out why my data is not a row when i open the csv file it looks like my carriage return happens after each item rather than after the entire string.

thanks

[altenbach]

---

vmrak wrote:

Mike my application is very similar to what you posted can you look at my vi I have attached it it was done in labview 8.2. I cant figure out why my data is not a row when i open the csv file it looks like my carriage return happens after each item rather than after the entire string.

---

Change the format input to %s (currently %s\r).

[vmrak]

Thanks altenbach I took out the \r then I put a for loop around everything so the vi would run 5 times and the data was typed in 5 rows as expected

what i dont understand is how did it know to write to the next row without a carriage return symbol

[RavensFan]

The VI knows to put a carriage return at the end of each row of data.  It's actually built into the array to spreadsheet string function that is inside this VI.

This VI is actually one of the LV supplied VI's which you can open by double clicking and see what it's doing inside.  (Be careful not to make any changes and accidentally save over it.)  It's not complicated.  It basically wraps a few functions up into a single subVI.

[vmrak]

thanks ravens fan

[vmrak]

I am on my last issue now with this how can I reset the start row in the write spreadsheet vi it is not clear to me. every time I run my program even after fully exiting I start to print on the row after the last row that was printed to. Evidently this information must be stored somewhere but I dont see where