Hello,
I noticed your post was in the DAQ group, but you didn�t mention which
programming language you are using. This answer is tailored to
LabVIEW, but if you are using something else, let me know. Since you
are running such a short test, it might be easier to acquire all of
your data first and then write it to a spreadsheet file.
If this is not preferable, you could use lower-level file VIs. Using
a VI such as the �Write To Spreadsheet File� within a while loop is
inefficient since it opens and closes the file each time it writes a
new value. One of the fastest ways to write to a file is to first
open the file. Then in your while loop, perform your data acquisition
and write to the file. Finally, close the file after your while loop
completes. If thi
s is what you are already doing, you could try
writing to a binary file instead of an ASCII file.
Try acquiring your data and then writing it to a file. Or try using
lower-level file VIs to increase the speed of file writing. If this
does not address your problem, please provide some additional
information such as the VIs you are currently using to write to the
file or post all or part of your VI.
Grant M.
National Instruments
