How to set/get cell values for password protected Excel workbook
How can we set/get cell values to/from the password protected Excel workbook?
With the steps described in the following URL, the password protected Excel workbook itself could successfully be opened:
https://community1.pega.com/community/product-support/question/openspan-71-how-open-password-protected-excel-workbook
But I couldn't tell how we can set or get cell values after that. I guess we need to use proxy or script component to achieve it, but could not tell "how" exactly.
Pegasystems Inc.
US
As Jeff shows, you first need to open an "empty" non-password protected document to open the connector. From there, I believe that calling the Open method would connect the connector to that document (allowing the GetCellValue or SetCellValue methods of the connector to work).
ServiceNow
JP
Thank you for your comments.
> I believe that calling the Open method would connect the connector to that document (allowing the GetCellValue or SetCellValue methods of the connector to work).
Actually it didn't. Even after calling the Open method for the second document, the connector is connected to the first "empty" non-password protected document. That's why I'm struggling with using Proxy...
Any suggestions?