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***
Accepted Solution
Pegasystems Inc.
IN
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.
Pegasystems Inc.
US
Did you select the check box "has header" in the calling activity, otherwise the excel will not be parsed.
Accepted Solution
Pegasystems Inc.
IN
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.