I am having a hard time getting my data to dump correctly into excel. I am currently using arbitrary columns and rows to test the program, and using the Report Generation Tool Kit. When I run the program and press the Boolean on the front panel, the data will dump once, but when I press the Boolean again to simulate dumping another round of data, it replaces the data that is already in the excel sheet. I have the "Append to new line?" function set to true so from my understanding it should move onto the next line of data. Attached is the VI I am currently working with.
Solved! Go to Solution.
Also, the NI-DMM Initialize subVI should NOT be in the while loop. You don't want to initialize every iteration. It belongs before the while loop.
Thanks for the response. I created a shift register for the while loop and attached it to the report generation tool. I also moved the true statement for the "Append to new line?" function on the "append text data" to outside of the case structure so that it is "always" true same as you did. Even with these changes, the data is still not appending to a new line. I've attached a screenshot of the updated code along with the VI. I am going to keep working at it and see if I can figure out a solution.
Hmm, that "append text" VI seems more suited to Word / HTML reports. When I look at the block diagrams the "MS Office Parameters" is not even wired up, but maybe my install is corrupted or something.
Anyway, I'd try the Excel easy table instead:
I looked into the same thing you did. It would seem that append to new line works only with MS office or word. I'm going to shift focus into using the easy excel.
Thanks for you help!