Support Article
MSOParseExcelFile parses a file with hidden rows incorrectly
KCP-344
Summary
When an Excel file has hidden rows, the MSOParseExcelFile activity does not parse the hidden rows or the rows that are present after the hidden rows.
Error Messages
Not Applicable
Steps to Reproduce
- Create an Excel file with some rows.
- Hide a few rows in the Excel file.
- Use the Pega out-of-the-box MSOParseExcelFile functionality to upload the Excel file.
Root Cause
MSOParseExcelFile is a deprecated API.
Resolution
Perform the following local-change:
Use pxParseExcelFile instead of MSOParseExcelFile API.
Tags:
Published December 2, 2021
Have a question? Get answers now.
Visit the Collaboration Center to ask questions, engage in discussions, share ideas, and help others.