how to use Write To Spreadsheet File in labview?

[Raviras]

hi,

i am trying to use Write to spreadsheet file.vi from the file I/O palette, but the example in the LV help are confusing.

What i am trying to do is, that i am using statistics object to give me

1. Mean
2. RMS
3. Standard deviation
4. Variance
5. Max
6. Min
7. Range
8. Total samples

I am using numeric indicator to display the results. Is it possible to write these in a spreadsheet file directly?

I know its possible but i am not able to do it. can someone help me with this.

 I also want to append (add data in the same file without deleting the previous readings).

I have attaced the VI that i am working on.

Ravi

[jrsisk0101]

I had this same issue a couple of weeks ago.  This is how I handled it.  You need to save your file as a text file and then you can import it into excel.  Hope this helps!

[Amd1480]

Hallo Raviras,

I just modified your vi a little bit. I hope that I could help you!

[Raviras]

hi dude,

I have LV 8.0, the VI that you mailed me is not opening. Is there a way to convert it into my version file?

tell me how to do it, i will try to do that.

Ravi

[Amd1480]

Hallo,
hier is the same vi in LV 8.0

[Raviras]

hi everyone,

thanks a lot...

you guys are awesome!!

[jrsisk0101]

I think you forgot the wire the STD of signal B to the build array... don't forget the wire that one!

[subhashmadhukar]

hi guys

i am not able to open any of these files.i need to use SpreadSheet Write To File.Please atleast provide a snapshot of the blockdiagram.

Thanks in advance

[Dennis_Knutson]

What exactly are you finding difficult about the Write to Spreadsheet File? The relevant part of the diagram is below but there isn't anything there that you can't get from the help or shipping examples.

Message Edited by Dennis Knutson on 10-04-2007 07:34 AM

[subhashmadhukar]

Hi thank you for the reply.

Actually i am previously giving the path name input as something like D:/Temp.txt.

Then its prompting some error.

Now i have changed it by using build path.Now that problem is solved.

I have some other problem. I want 2D data(Time data and measurement data) to be written into the file.

For that i have 620x100 array. so i want to keep them under Time and Data column seperatley.

Please help me in solving this problem out.(snapshot)