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
Have a question? Get answers now.
Visit the Collaboration Center to ask questions, engage in discussions, share ideas, and help others.