how to use Write To Spreadsheet File in labview?

[Dennis_Knutson]

Changing the extension of a bmp file to get around the ban on them is not appropriate behavior. I, for one, will not look at the image or answer your question.

[RavensFan]

And why did you post the question in a 2 1/2 year old thread when you already asked it here?

Please keep it in one thread.

[gruenlein]

Hello,

I also have some problems using the "write to spreadsheet file". Always the following error occurs:

[Yamaeda]

Since you have no path wired you should get a popup asking for file name. If you canel that you'll get this error.

/Y

[drmahdieh]

hi

i want to save on array to file and i write something to save this variable but i have a problem with it. when i run the program in every loop of while loop the program ask path address to save data. but i want choose path at first and program save all amount of variable in whole of program until i stop it. what shall i do?

 ( i attach an example about my question please give me solution with it or if it is rubbish, send me the answer with every thing is possible for you)

thank you

[mikeporter]

To solve your problem open the file outside the loop, then inside the loop write to it as many times as needed. Finally, close the file when the loop ends.

Mike...

[drmahdieh]

thnk you for tour answer

i have another problem. i have a varible that is just a nuber and it update in each loop iteration and i want to save all amount of this variable in whole program and I want to save it in excel file. what I must do?

thanks

[mikeporter]

You can either save the value point by point inside the loop, or accumulate it into an array and save it all at once when the loop stops. The correct choice depends on how fast and how long the loop runs.

Mike...

[Muni06]

Hi,

I want to write my loop execution time in date/time format and frequency in Write to Spreadsheet using 2D array . I tried but failed. Can you please give me any clue to solve my problem. Here is my vi.

Thanks

[crossrulz]

1. You should close the instrument AFTER the loop.

2. Why the 2D Array?  I only see a frequency measurement being taken.  You should use a 1D array since you should write the data each iteration of the loop.

3. I would actually advise against using the Write To Delimited File VI since it opens and closes the file with each call.  Instead, open/create the file before the loop and close it after the loop.  Inside of the loop, you can use the Format String to create your row of data.  Part of the format can be how you format the timestamp.  Here is a very quick example of what I mean.