Question

21
Views
Sharmila Katakam (SharmilaK2263)
LLC

LLC
US
SharmilaK2263 Member since 2020 1 post
LLC
Posted: May 24, 2021
Last activity: May 24, 2021
Posted: 24 May 2021 2:44 EDT
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.

 

Binary Template

 

Excel File

Appreciate your response.

Thanks

Sharmila

 

***Edited by Moderator: Pooja Gadige to move from Pega Academy to Product, add platform capability tag***
Pega Platform 8.1.3 Case Management Data Integration Financial Services Senior System Architect