Support Article

Excel download is not working after upgrade

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 15, 2017 - Updated May 17, 2017