Question
Cognizant
IN
Last activity: 29 Apr 2020 7:45 EDT
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***
Pegasystems Inc.
US
Perhaps this related post will help:
https://collaborate.pega.com/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.
Cognizant
IN
Those links didn't help. Is there anyone to help on this?
Pegasystems Inc.
US
Hi @Govindarajan,
Do you use Robotics? Does this post help you?
Cognizant
IN
No we are trying in Pega
JPMorgan Chase & Company
US
Hi,
As of my understanding, not possible to parse the password protected files through MSOParseExcel activity.
Updated: 30 Apr 2019 0:49 EDT
AS
JP
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.
Accenture
NL
Is there a solution yet to parse the password protected excel file? Any help would be appreciated.
Tata Consultancy Services
IN
Hi Govindarajan/Dinesh,
Did you got any solution to parse password protected file?Any help would be appreciated.
Thanks,
Shailendra
Pegasystems Inc.
IN
Hello Shailendra,
This is an old post without any recent activity.
Please create a new post to seek resolutions to your query.
Thanks,
Pallavi M | Moderator | Pega Collaboration Center