03-07-2014 07:23 AM
Hi everyone,
can anyone help me with this problem?
I've been using this part of the program for over a year an suddenly this error occures. But not always, mainly at the very beginning of my tests when the file should not be open.
Info: I'm using a realtime PXI-System. Maybe the amount of data can cause the problem? (about 2MB)
Grüße
Meike
03-07-2014 07:33 AM
03-07-2014 07:40 AM
Hey Gerd,
Thanks for your quick answer.
Since I don't have access to my PC's hardware I save the data on the PXI-System and collect it via FTP afterwards.
Best regards
Meike
03-07-2014 07:46 AM
Hi Meike,
is the file opened by a different program? Do you try to access it by FTP in parallel to your VI?
You could use basic file functions instead of WriteSpreadsheetFile. That way you could open the file before starting the loop, keep it open all the time and close it once you're finished - with the added benefit of easier error handling…
03-07-2014 08:05 AM
Hey GerdW,
not, it's not accessed by FTP in parallel.
Is there a maximum of lines or colums you can write with Write Spreadsheet File ? Or maybe it takes too long and gets disturbed by the timed loop above? But still, there are greater files for which the function works fine.
Maybe I should try your idea of simple file-open-write-close programming. 😕 on monday then...
Have a great weekend!
Meike
03-07-2014 08:12 AM
03-12-2014 08:29 AM
Hey GerdW,
Thank you very much for your help!
It's working now... and I didn't do anything in this code :-).
Seems like the spreadsheet function takes hours (well, not hours but more than 500ms?) to close the file again.
Now I wait for a second before reading the file and everything is fine.
Best regards
Meike
04-24-2022 09:21 PM
Can you share the reference where you have gone through?
As it is mention to use wait time untill it closes the reference.
im also facing such issue in the Application where im using the read Spreadsheet function in reentrant VI.