Remove worksheet VI - Report Generation Toolkit (LabVIEW 8.6)

[Troy12]

Hello,

I am using the Report Generation Toolkit that ships with LabVIEW 8.6 for creating an Excel report. I am looking for a way to delete spreadsheets in a workbook. I did come across couple of message posts in the forum which mentioned about worksheet removal using some VIs that were shipped with previous version of LabVIEW. I could not find the built-in VIs in newer version of report generation toolkit (the one with LabVIEW 8.6).

Is there a way I could remove worksheets in LabVIEW 8.6?

Thank you.

[Tanya_V]

Hi Troy12,

The best way to remove a worksheet without having the add-on Report Generation Toolkit for Microsoft Office is to use Activex. You have to get an Activex reference to a worksheet and use the Delete method, as shown below.

Let me know if this does what you're looking for.

Take care!

[Darren]

Assuming you're using Report Generation Toolkit 1.1.4 with LabVIEW 8.6, you can use the following VI (in the Report Generation > Excel Specific > Excel Advanced subpalette) to gain access to your current Worksheet and/or Sheets object:

Note that this VI is not available in Report Generation Toolkit 1.1.3.

[Troy12]

Thanks, Darren.

I was unable to find this VI in Advanced subpallete. How can I tell which version of Toolkit I have?

[Darren]

---

@Troy12 wrote:

How can I tell which version of Toolkit I have?

---

Go into Measurement and Automation Explorer, then look under My System > Software > LabVIEW 8.6 > Report Generation Toolkit for Microsoft Office.  That will tell you what version you have, and most likely it's 1.1.3.  To gain access to those ActiveX references, you'll need to upgrade to version 1.1.4.