Microsoft Office Report Toolkit alternatives / find all report toolkit subvi references

[michele.santucci]

Hi,

I'm working with a large LabView 2013 project that uses Microsoft Office Report Toolkit and I would like to find a NON ActiveX

alternative.

Make:

thinking about writing a simplified report toolkit with a very basic set of features because I have a good experience in

handling openxml documents in .net (OpenXML SDK).

Buy:

looking for a royalty free report engine that does not require Microsoft Office installation but OpenXML formats compatibile

(I have a lot of Excel templates to save).

In both cases I need to have a precise idea of what report toolkit subvis are 'called' within my project that's pretty large and

I would like not to inspect every single VI to check for such calls.

There's a way to do such inspection in a less time consuming way?

best regards,

 Mike

[LVNinja]

I haven't used it but I found this GitHub - pettaa123/Open-Xml-LabVIEW: Wraps basic Open Xml functionality for Excel file reading

check if makes sense for your use. 

[Bob_Schor]

---

@michele.santucci wrote:

I'm working with a large LabView 2013 project that uses Microsoft Office Report Toolkit and I would like to find a NON ActiveX alternative.

---

Hello, Mike.

     I'm assuming that you are referring to NI's "Report Generation Toolkit" which can open Microsoft Excel and interact with it (typically by reading and writing Worksheets in a Workbook).  I started using LabVIEW before it was introduced, and its predecessor was much harder to use.

     There have been some "recent" changes in the last 2-3 years.

• The Report Generation Toolkit is no longer being offered as a "stand-alone" product -- it is only available in the Professional edition of LabVIEW.
• In the not-too-distant future, when most of us will be forced to use Windows 11, it is not clear if versions of LabVIEW older than LabVIEW 2022 will be supported, which suggests that older versions of the Report Generation Toolkit won't run.

     There may be other options.  Have you looked into the LabVIEW Tools Network (which you activate through VIPM (which you should have installed when you installed LabVIEW).  In particular, check out the Viewpoint Xlsx Toolkit.  They describe it this way:  "The Xlsx Toolkit by Viewpoint Systems provides a simple LabVIEW API to create native Microsoft Excel xlsx workbooks, without installing Microsoft Excel or using ActiveX /COM."  There might be other packages out there.

Bob Schor