Question
LLC
US
Last activity: 24 May 2021 2:44 EDT
Problem in parsing the excel file using OOTB pxParseExcelFile in Pega 8.1.3
I am trying to upload and parse the excel content using pxParseExcelFile activity, but system shows exception (Data-Portal)pzUnrecognizedFileTemplate. Below are the steps, Excel Template and Excel file snippets.
Steps:
1. I have created a section with AttachFile control and a Button.
2. Property used on AttachFile control is pxRequestor.pyFileUpload
3. Created an activity in pyWorkPage class and i did call pxParseExcelFile for parsing and passed below parameters.
FSFileName: pxRequestor.pyFileUpload
TemplateRFB:"excel!TemplateID!xlsx"
sheetsToParse:"SheetName"
sheetWiseData:""
hasHeader:"true/false"(I did try both)
bDeleteFile:""
outputPageName: ""
4. This activity is being called on Button.
Appreciate your response.
Thanks
Sharmila