Skip to main content

This content has been archived and is no longer being updated. Links may not function; however, this content may be relevant to outdated versions of the product.

Support Article

Excel download is not working after upgrade

SA-38015

Summary



The user has upgraded from 7.1.7 to 7.2.2 and after upgrade, they are unable to open the downloaded excel file from the link present in the work object.


Error Messages



"The file is corrupt and cannot be opened" when tried opening the downloaded excel file.


Steps to Reproduce



Download the excel file from the work object.


Root Cause



The user have their own custom rules to generate and download the excel file instead of using "MSOGenerateExcelFile" OOTB functionality. In 7.1.7, they have implemented a similar activity as of OOTB and have used a custom function "abc" in their own library instead of using "DCOXLGenerateZipEntryMap" function from ExcelIntegration library in the excel generation activity.

During upgrade, all the OOTB functions are upgraded and in 7.2.2, the function "
DCOXLGenerateZipEntryMap" uses "createElementNS" method which takes two parameters where in, 7.1.7 OOTB function "DCOXLGenerateZipEntryMap" uses "createElement" method with only one parameter. Since the custom code uses the same method "createElement" after upgrade as well, the function failed in generating the excel file properly and hence is the error on opening the downloaded file.

Resolution



Ensuring that the required changes are made in 7.2.2 in the custom function as that of the upgraded function "DCOXLGenerateZipEntryMap" with the right method "createElementNS" along with two parameters resolved the issue.

Published May 17, 2017 - Updated October 8, 2020

Was this useful?

0% found this useful

Have a question? Get answers now.

Visit the Collaboration Center to ask questions, engage in discussions, share ideas, and help others.

Did you find this content helpful?

Want to help us improve this content?

We'd prefer it if you saw us at our best.

Pega Community has detected you are using a browser which may prevent you from experiencing the site as intended. To improve your experience, please update your browser.

Close Deprecation Notice
Contact us