Hi Pega Team,

I have a requirement to validate the header row of an uploaded Excel file before processing the data.

I am currently using the pxParseExcelFile activity to parse the file, and the data is being uploaded successfully. However, I noticed from the documentation that the header row is not treated as a property-mapped row, which means the header values are not available on the clipboard.

I tried several solutions from the Pega support forum and other sources, but none of them worked in my case.

Could you please advise how I can:

1. Retrieve the header row (first row) of the uploaded Excel file, and

2. Validate whether the header matches the expected format before processing the data?

If there is an alternative method or best practice to handle this scenario (e.g., using a custom Java step, Apache POI, or another approach), I would really appreciate your guidance.

Thank you!