how to save data to file continuously in fixed interval

[67679042]

Hi,

Could anyone kindly teach me on how do i save data from a table in the front panel to the excel file continuously at fixed interval in the same column arrangement?

Thanks alot.

[TiTou]

Hi,

Are you sure you need to save your data in an excel file (xls) or you just need it to be readable by excel (any tabulated texte file) ?

It is possible to write to excel file with activeX tools but it's not as easy as writting a tabulated text file...

[67679042]

Hi Titou,

Part of the requirement of my project is to transfer the data from a table in the front panel to an excel file. In which, the ESVD instrument will take measurements and readings, then it will log the result to the table in the front panel. Then, the table reading has to be transfered to the excel file at fixed interval.

Thanks for your kind attention.

[MilkyStone]

Base on my experience in this aspect, I suggest you to use the tabulated text file to  achieve your goal, it's easy and feasible to save the table in the front panel.

[Nishant]

Hiii, 67679042

         Here i am attaching the vi in which i have shown that how to store the data into the file with time, if you select any of the existing excel file, it will store the data in the tabulated form, your file extension will be .xls but it will store the data as in CSV(Comma seperated Value), and as i have use the timed loop, it will store the data at one second interval, so you can change that time as you want. you can also modify the vi if you dont want the timestamp and just attach the table data, instead of random data.

Thanks,

Nishant

Message Edited by Nishant on 04-06-2006 11:28 PM

[67679042]

Dear Nishant,

As i am currently using only Labview 7.0, i could not open the file that you have sent me. Is it possible that i could have an alternative version to your program please?

Thanks alot.

[Nishant]

Hiii,

       Here with this i am attaching that vi in the LV7.0 version, so that it is possible for you to see that vi.

Thanks,

Nishant

[67679042]

Dear Nishant,

Thanks for the modification. However, i still have trouble opening it.

[Nishant]

Hiii,

         Can you tell me what is the error you are facing in opening the vi, i can change you the file accordingly, cos if it is in the 7.0 version then it should open OK, but still problem means something missing out of file, please tell me what is missing so that i can change vi for you.

         I am sorry because i could not upload the jpg files cos here in paint there is no option of saving in jpg and this forum is not taking bmp asa valid format.

Thanks,

Nishant

[Nishant]

Hiii,

       I ve onvert those bmp files into jpg files and here i am attaching those two file here, but i still forcing you to tell me the problem cos vi will help you more than jpg files.

Thanks,

Nishant