Is there a way to add custom functions to the Report Generation Toolkit?

[ben64]

I would like to be able to delete unused sheets from an Excel report without having  to reopen the file (and Excel) to do it using ActiveX. It is probably not possible since the NI_Excel.lvclass is locked but maybe there is some other way to do it.

Ben64

[aeastet]

I think they would be better served if you put them in a user library so that way in the future they are easier to move when you do have to upgrade LabVIEW. It seems that they would be easier to manage too.

I have all kinds of special VI that modify existing LabVIEW stuff and I keep them in the user library. This way I just pick up my user.llb floder and move it to the new version and I have everything.

[P@Anand]

I just tried to explore the Excel report gen toolkit. In that one when you open a Method (Invoke node) of an excel worksheet you have one option called delete after giving the name of the worksheet that you wanted to delete use the method and check it. Even I have never tried these sort of things.

[P@Anand]

Yes It is working I am able to delete the worksheet.

[ben64]

---

@P Anand wrote:

I just tried to explore the Excel report gen toolkit. In that one when you open a Method (Invoke node) of an excel worksheet you have one option called delete after giving the name of the worksheet that you wanted to delete use the method and check it. Even I have never tried these sort of things.

---

It not clear exactly what you mean. but as an alternative I found the Excel Get Active X References.vi in the toolkit, I can use this vi with the delete method. Initially the issue I had was that you can't unbundle the Excel report to get acces to the activeX references when you're outside the NI_Excel.lvclass (as in the following picture).

Ben64