Question

How to Parse the Password Protected Excel File in Pega 7.2.1

We do have a requirement, In Email Listener, we get a password protected Excel File as an attachment. I do get the bytestream in pyAttachment Page. We need to parse the password protected Excel Attachment Content. Offline we know the password as well. How to parse the attachment content. Could someone please help?.

***Edited by Moderator Marissa to add SR Details***

Group Tags

Comments

Keep up to date on this post and subscribe to comments

Pega
March 20, 2018 - 6:05am

Perhaps this related post will help:

https://pdn.pega.com/community/pega-product-support/question/parse-excel-data-pega

The password protection may not be mentioned there, but perhaps in the mentioned example there is a place to work with passwords.

March 28, 2018 - 6:03am
Response to HOULJ

Those links didn't help. Is there anyone to help on this?

April 5, 2018 - 1:48pm

Hi @Govindarajan,

Do you use Robotics? Does this post help you?

Marissa | Community Moderator | Pegasystems Inc.

April 23, 2018 - 2:40am
Response to MarissaRogers

No we are trying in Pega

May 3, 2018 - 7:34am
Response to Govindarajan

Hi,

As of my understanding, not possible to parse the password protected files through MSOParseExcel activity.

 

April 29, 2019 - 11:03pm

Usually many people use VBA code methods, although sometimes it seems cumbersome. I like to use an easier way to copy and paste and upload to Google Sheets to unprotect Excel.

August 29, 2019 - 4:14am

Is there a solution yet to parse the password protected excel file? Any help would be appreciated.