Convert Excel Sheet to a Pagelist property without using Binary File (excel template file).

General
1

I have a requirement wherein I need to read the excel attachement I’m getting via an email listener and save that data to a table. When we run a email listener, whatever the attachements we are posting to the email, those attachments can be seen on “pyAttachmentPage” and “pyAttachedValues(1)” has a encoded content(presuming base64).

If we pass that “pyAttachedValues” to the OOTB “pxParseExcel”, we have to make sure we use a “excel template via binary files”. That way, it will be mapped to the pagelist property that I mention in the template. But in my scenario, I don’t want to use an excel template.

Whatever the excel content that is available, I want to convert it into a Pagelist so that I can loop through.

Any suggestions?

2

@KVPVishnu Binary file template is mandatory for pega to parse excel file.

https://support.pega.com/question/how-can-we-read-excelcsv-attachments-email-email-listener-and-save-value-data-table

https://support.pega.com/discussion/reading-excel-sheet-attached-email-using-email-listener-and-copy-data-clipboard

3

@Anoop Krishna What would we pass for “FSFileName” - Should I pass the pyAttachementName(1) value here ??

4

@KVPVishnu that’s the file name from service export directory. So first you need to move this file to service export directory. Then use that file name in FSName.