Question

pxParseExcelFile failed to use Excel template with header

I have an acitivity which calls @baseclass.pxParseExcelFile to parse Excel files using an Binary file Excel Template. It failed to parse any excel file and threw errors in Log:

Invalid template. CLM1_template has 2 row(s) which is not allowed. This sheet will be excluded from parsing. NOTE: Template sheet without header must have only 1 row(property info)

my Excel template has two rows, first row as the header and second row containing property references like {.ClaimList().ClaimID input}

***Moderator Edit-Vidyaranjan: Updated SR details***

Group Tags

Correct Answer
July 26, 2019 - 8:49am

Hi,

I see from the tracer that the "hasHeader" checkbox has not been clicked. Please check the checkbox "hasHeader" in the calling activity and try.

Comments

Keep up to date on this post and subscribe to comments

Pega
July 25, 2019 - 7:51pm

Did you select the check box "has header" in the calling activity, otherwise the excel will not be parsed.

 

August 12, 2019 - 10:02am
Response to SusanLiu

Thank you it worked!

Pega
July 25, 2019 - 7:52pm

See attached screenshot.

Pega
July 26, 2019 - 8:49am

Hi,

I see from the tracer that the "hasHeader" checkbox has not been clicked. Please check the checkbox "hasHeader" in the calling activity and try.