I have been working a lot with the Microsoft office add-on toolkit for report generation and noticed a few missing functions. One thing was that if you had a template that has tabs in the workbook that were charts ( when asked where you want to display the data when creating a graph you have the option for in the worksheet or in a separate chart) the worksheet selector does not recognize these tabs. So if you needed to change the worksheet name based on say a test name or configuration it will just skip over the tab. Or if you wanted to change the data going to the graph it will not let you select it with the select worksheet sub vi in order to further process it.
A second problem I had was replacing the Title of a graph in excel sheets. Apparently you can only manipulate graphs created by Labview using the toolkit. Ones that are already present in templates that are loaded are not changed by the toolkit functions. This means graphs are pretty much useless unless you write a lot more code that grabs data from sheets and creates graphs in different workbooks. It can be done, but for a workbook like mine that had 64 tabs it can be a nightmare. Just a thought I had that would save a lot of time and be useful for a lot of people interested in manipulating excel sheets and doing post processing on them. Still love Labview though.
Any idea that has not received any kudos within a year after posting will be automatically declined.