Data Writing Speed for Excel Sheet while taking data from PCI DAQ card

[Nishant]

Dear All,

          I am taking the data form the card EX-92026 pci card and writing those datas into the Excel sheet, now i want the data at the speed of max of 10 miliseconds but while writing the data into excel sheet, it shows the diff of 15 ms betn 2 readings, and the card specs says it takes the time of 500 microsecs to give the data, so is there any effect of timing, while writing data into excel sheet? is labview take more time, i am using the Open file, write file and close file method and write to spreadsheet file method, but none of them is giving me the effective timing that i wamt, so can u tell me how can i reduce it??????

Thanks,

Nishant

[Aitortxo]

Hi Nishant:

I think I don't understand you very well. If you are using OpenFile, CloseFile and WriteToSpreadsheet VIs, you are not dealing with excel files, but text files.


Writing to file is costly in time. You can:


Open the file just once and

during de process use just file writing VIs as 'write to spreadsheet'... or a more simple one 'write file'

Close the file once at the end.

If you need the process to be faster, you can save all the data at 10ms rate in an array and write to file at the end.
Or write to file every second what you got the last second.

Hope it helps
Aitortxo.