Question
Cognizant Technology Solutions
US
Last activity: 25 Sep 2024 22:28 EDT
Convert Excel Sheet to a Pagelist property without using Binary File (excel template file).
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?
Accepted Solution
Updated: 25 Sep 2024 22:28 EDT
Bits in Glass
IN
@KVPVishnu Binary file template is mandatory for pega to parse excel file.
Cognizant Technology Solutions
US
@Anoop Krishna What would we pass for "FSFileName" - Should I pass the pyAttachementName(1) value here ??
Bits in Glass
IN
@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.