Excel download is not working after upgrade
SummaryThe 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 ReproduceDownload the excel file from the work object.
Root CauseThe 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.
ResolutionEnsuring 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