LabVIEW
how to use write to spreadsheet.vi
- You should probably clear the data in the shift register after writing.
- You use different delimiters for writing vs. reading spreadsheet file.
altenbach wrote:
- You should probably clear the data in the shift register after writing.
You accumulate the 2D string array data in an uninitialized shift register. The contents of it grow without limits. On command, you append everything inside the shift register to the existing file (if append is true), this means you write all old history data instead of only the data since the last save operation.
You should also initialize the shift register to start empty. Currently, it will retain data from earlier runs.
The main problem is that your data in the shift register grows without limits, so the longer the program runs, the more data is to be saved. Ultimately, you'll run out of resources.
altenbach wrote:
- You use different delimiters for writing vs. reading spreadsheet file.
When writing the spreadsheet file, you are using a delimiter of three characters: ","
When reading from spreadsheet file, you are assuming the default tab delimiter.
-------> The delimiters must match!!!!
Overall, your program is very convoluted and different parts step on each others toes. For example whenever you are in read mode, the file never changes, yet you read the same file over and over again. Makes no sense. Once is enough. LabVIEW is good at parallel operations, so you could easily restore data from file wile continuing to acquire.
Here's a quick draft showing some alternatives. If you would set the file write operation to "append", you should also delete the wire going to the output tunnel in that case and make the tunnel to use default if unwired. This way the shift register clears when you write, but accumulated data when you don't.
