Parse excel header for validation
Have a business requirement to validate the excel header i.e user should upload the excel with the same header as in template, before loading the data to the work object.
We are using pxParseExcelFile OOTB activity to achieve parsing the excel data but could not find any steps to parse the excel header.
Tried by setting the parameter hasHeader = true, but no luck.
Please let us know is there any OOTB activity available to achieve it. Or do we need to go with customize java code.
ING Nederland
NL
Hi @AnithaG84, assuming you are calling this activity "pxParseExcelFile" on a step page which is of class "Code-Pega-List", let's say the page name is ExcelData, I can EITHER then do a loop and "Page-Copy" of the ExcelData page to a local pagelist, say, Primary.ImportedExcel(<APPEND>) and my header should be in ImportedExcel(1) OR my ExcelData.pxResults(1) can be used and should also have the header.
In the next step I can check the contents of the (1)st page with my required/original header names and if they don't match set some error so that the case cannot be progressed.