Question
Synechron Inc
US
Last activity: 25 Mar 2022 14:28 EDT
Parse Excel file from email attachment
I have a requirement, that I am getting an Excel File as an attachment in the Email Listener and I need to parse the data from that Excel File. Can someone please help me to parse the Excel data and Copying it to clipboard.
Pegasystems Inc.
IN
When there are attachments in the email Pega puts all those attachments on the page named "pyAttachmentPage".Please refer to createworkfrommail activity. From there you can maintain your logic if the file type is excel and use the activity: pxParseExcelFile to convert the excel data to the page-list format in the clipboard.
Excellus Blue Cross Blue Shield
US
@palas3- pxParseExcelFile only parses an excel sheet per row and considers each column as a case property. Is there a way to parse the Excel file where we can retrieve values from specific cells either by mentioning their index, like B19, X24, etc, of the Excel sheet instead of the way the pxParseExcelFile does?
Thank you.