Read and write Excel Reports without ActiveX

[Vinaygowda]

Hello ,

As of now I can able to read and write excel using ActiveX no issue its working fine 

my senior is suggesting me to not to use the ActiveX there may be license issue it seems but I don't know exact reason.

But I want to read and write excel file without using ActiveX. And I think we can do it by using Report generation Toolkit can any one help how to do this. also I have searched in NI forum but I got some thing attached bellow

And I couldn't able find the marked functions 

please help me on this I really I don't know how to get those function and how to read and write using this report generation toolkit.

Thank You 

Regards

Vinay

[GerdW]

Hi Vinay,

---

@Vinaygowda wrote:

As of now I can able to read and write excel using ActiveX no issue its working fine 

my senior is suggesting me to not to use the ActiveX there may be license issue it seems but I don't know exact reason.

But I want to read and write excel file without using ActiveX. And I think we can do it by using Report generation Toolkit can any one help how to do this. also I have searched in NI forum but I got some thing attached bellow

---

Under the hood the RGT uses the very same ActiveX calls as you do right now, so replacing basic ActiveX nodes by RGT functions will (technically) not change anything. (It may become easier to do certain things as NI provides some ready-to-use functionality.)

The main point not to rely on ActiveX is to avoid the requirement of having a valid MS Office installation (of the correct version) available on the computer!

To handle Excel files completely without using ActiveX you can look for certain libraries in VIPM, like XLR8. They provide similar features as RGT, but can do all this without requiring ActiveX - and also without the need to install MSOffice…

---

[Bob_Schor]

When you open the LabVIEW Forum, there is a Search bar at the top.  Type "Revised Excel Example", wait 1 second for the Search, then choose the one that looks appropriate.  This example was written in 2014, for an older version of LabVIEW and an older version of Excel, but will "mostly work".  You should change "New Report" on the Block Diagram with the current RGT VI "Create Report".  You might also need to fix one of the functions (and information on how to do this is also to be found on the Forums).

Bob Schor

P.S. -- I am a great fan of the RGT.  I gave up on the ActiveX approach shortly after NI released the "modern" RGT around a decade ago.