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.
Pegasystems Inc.
US
Hi @Govindarajan,
Do you use Robotics? Does this post help you?
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.
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