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***
Hi,
As of my understanding, not possible to parse the password protected files through MSOParseExcel activity.
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.
Is there a solution yet to parse the password protected excel file? Any help would be appreciated.
Hi Govindarajan/Dinesh,
Did you got any solution to parse password protected file?Any help would be appreciated.
Thanks,
Shailendra
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
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.