I currently have a VI set up to write data from different table controls, boolean controls, and string controls to a .xls format excel file. However, all that data is written to one worksheet. I have a second data table that is recording the user's clicking actions. Knowing that those actions can add up pretty quickly, I want to store that data to a separate worksheet of the same existing .xls excel file.
My issue is that my current way is opening up the .xls file to add the second worksheet and then the data to finally close the excel program. I don't want excel to open up and close, so I'm wondering if there was a way to store the data to a second worksheet without opening up the actual user interface of Excel.
I've read into storing the data as a TMDS file extension, but then I would have to install the TDMS add on into excel to read it, if I wanted to see if the information was being stored correctly. If I went the TDMS route, would it be possible to store the data from the different controls I have into their respective columns/rows/worksheet and also later read it back to those controls later on?
