Reading of a password protected excel file

[valiyattil.26]

Hello...

I want to export data from a password protected excel file...how it's possible?..need to use ActiveX functions? please help me

[pitol · Accepted solution]

I'm afraid that Report Generation Toolkit does not support password protected Excel files.

But you can easily use ActiveX.

Attached you will find an example of such code.

[valiyattil.26]

Thank you sir......thank you very much....it's working....thanks alot...

[valiyattil.26]

Sir, 

Once again thank you for your code...I also want to know the same using rgt.. with rgt it's possible to write to a password protected excel file...but reading not working...sir,  I think with rgt coding will be easy.. please help me in this regard

[pitol]

I was wrong in my previous statement.

RGT can open password protected Excel file but only after small modifications.

Please check solution under:

https://forums.ni.com/t5/Example-Program-Drafts/Using-password-protected-Excel-templates-for-Report-...

[valiyattil.26]

Thank you sir...