save_file_in_excel_continously

[keeper]

Hi,
i want to create a VI that is able to save continously in excel with date and time and data from a external source inside a single file until i press "stop" it will just continue recording the data

[Xu]

Basically, you can use "Write To Spreadsheet File" vi in a loop.

[BJD1613]

I would suggest using the intermediate file i/o vi's. Open a reference to a file outside your loop and then using the write function write a tab or comma delimited string with and end of line constant. This will then create a new row each iteration. Outside your loop close the reference to the file. If you use the write to spreadsheet function you will be opening the file and closing the file each iteration of the loop. This can prove to be costly. Hope this helps.

[Xu]

You are right, BJD1613.

[keeper]

I am quite new to this labview can you show me instead on a VI thanks you....

[Ankita A.]

Hi,

There is an example that ships with LabVIEW called "Write to Text File.vi". You can find it in the example finder by going to Help >> Find examples. This will give you a good starting point.

Reagrds,
Ankita A.