08-20-2014 01:49 PM
I have a DAQ device which is reading 14 Thermocouples at 1 measurement every 4 seconds. I took around 4 hours worth of readings before stopping the experiment, the last reading was at 12:30 but I didn't stop process until 13:15. The file size is 2.5mb, any reason why it didn't continue to write data or is there a limit to how much can be written to an excel file? Any advice would be greatly appreciated.
08-21-2014 05:34 AM
Hi Matt,
Could I ask what DAQ device you are using?
Thank you.
08-21-2014 05:40 AM
Hi, I'm using a DAQ-9174 with a NI-9213 Thermocouple module.
08-21-2014 06:22 AM - edited 08-21-2014 06:26 AM
What version of Excel are you using? Excel used to have a limit of 65,536 lines (or something around there). What you are describing sounds a lot like you ran into that issue.
Can you share some code? Maybe we can give you a better way to save and view the data.
08-21-2014 06:56 AM
Hi,
It might potentially be an issue with the USB port on your computer. What operating system are you using? The USB Power Management in Windows tends to cycle power to the USB port after a period.
08-21-2014 07:03 AM
Hi,
I'm using Windows 7 Pro.
The excel file had 3197 lines before it terminated.
Thanks for your help
08-21-2014 07:08 AM
Hi,
You could go into the Device Manager and edit the power management setting of the USB device. There is a setting called "Allow the computer to turn off this devoce to save power" which shuts off things connected by USB after a period. If you deactivate it you might be able to fix your issue.
Also have you included any error handling to see if an error causes the device to stop logging?
Thank you.