How can I continuously save the data into the Excel spreadsheet

[Jasmine]

without pop up a dialog box for each set of data?

[Doug (CapeFl)]

Depends on your exact VI call to write to the spreadsheet. However, if you wire in a 'constant' with the file path, it will happen automatically, and thus no pop-up dialog box.
You'll see on the 'Write to Spreadsheet.VI' an input for file path. It defaults to a dialog box, unless you force a direct path. Good Luck - Doug

[Filipe A.]

Jasmine;

If you wire a constant with the path and name of the file you want to save, Labview will not ask for the file when saving the data. Make sure to wire a TRUE constant to the "append file" input on that VI as well. By doing that you will overwrite the old data on that particular file.
By doing that another prompt will appear asking for permition to append the file. You have the option on going inside the Open/Create/Replace.vi, inside the Write to Spreadsheet.vi and disable that message. After changing that, just make sure those two VIs with another name, just to avoid to overwrite the original Labview VIs.
Hope this helps.
Filipe
Application Engineer
National Instruments

[ian_fung]

hi

I have immediately built this vi for your reference.
You may modify it to suit your requirements.

Hint:
1) Set Append-to-File? : FALSE at each entrance to the program so that you have an option of whether to append or to overwrite the previously saved file.

2) Set Append-to-File? : TRUE when you are in your loop for data collection.


Hope this help in your LV programming.

Cheers
ian.f

[chutla]

You can automatically name files using the time/date functions. This can be pretty elaborate, but very useful if you're collecting data continuously. I've attached a PART of a vi. that does this. The vi. will show up as broken, because you need to add your input. But you should get the idea.