Support Article
Unable to open MSOGenerateExcelFile API generated Excel file
SA-67751
Summary
When using a third party JAR file (such as, saxon9.jar file), to create a new functionality that is not present in Pega, unable to open an Excel file that is generated using MSOGenerateExcelFile API. This occurs only when the JAR file is imported in the instance.
Error Messages
For Dry Run and Reg2, getting below error:
** Exception while invoking function: pega_appdefinition_excelintegration.DCOdocumentToBytes--(Document), DOMSource cannot be processed: check that saxon9-dom.jar is on the classpath
Steps to Reproduce
- Open the User portal.
- Click the Download button to download the Excel Rule-File-Binary (R-F-B).
Root Cause
Saxon9 parsing is not available.
Resolution
An enhancement request, FDBK-28809, has been created for consideration by Pega Product Management.
As a local-change, use the out-of-the-box Apache implementation.
Published May 7, 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.