LabVIEW

cancel
Showing results for 
Search instead for 
Did you mean: 

Using Excel .DOT template file to create a workbook

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.
0 Kudos
Message 1 of 2
(2,774 Views)
Hi labview_beginner,
this library should do what you need. Change your specific data and pathes and it should work for you.
Hope it helps.
 
Mike
0 Kudos
Message 2 of 2
(2,764 Views)