Support Article
MSOParseExcelFile reads values to the incorrect cells
SA-71001
Summary
MSOParseExcelFile reads values from the imported Excel using a template. The property to read value is specified for each cell. However, the values are not read to the correct cells, according to the template.
Error Messages
Not Applicable
Steps to Reproduce
Read the values from the imported Excel using the MSOParseExcelFile.
Root Cause
A defect in Pegasystems’ code or rules. The templates with an empty row or column work incorrectly. The xlsx file that was uploaded by the user consisted of empty rows.
Resolution
Perform the following local-change:
- Remove the empty rows and columns from the template
- Upload the xlsx file
Published January 10, 2019 - Updated October 8, 2020
Have a question? Get answers now.
Visit the Collaboration Center to ask questions, engage in discussions, share ideas, and help others.