Hello All
Following is what I want to achieve in Labview:
1) Acquire data (upto 4 1-D column arrays, each may have upto 100 voltage readings)
2) Open Excel .DOT template file
3) Dump each array into a column array into particular location in excel. I willl know this desitation cell before hand - for example array_1 would go into sheet 1, cell A1 to A100, array_2 would go to sheet 5, B15 to B50, so on and so forth.
4) Once all the data is dumped into the excel template, do a "save as" and save the template as a work book so that the initial .DOT template file is unharmed.
5) Now take a particular worksheet from this workbook (say worksheet #8) and print this worksheet to a PDF writer.
I do not have Report Generation Toolkit. Prior to this project, I have been able to dump the data into Excel sheet, but I had to create a new worksheet every time. I have never done this using a pre-formatted template and then saving it as a workbook.
Any help would be appreciated.
Thanks in advance.