Facing issues in downloading excel file

User Experience
, , ,
1

Hi,

We upgraded our application from 7.4 to 8.5.

But excel file is not exporting.

Please help me in this scenario.

Thanks

2

@AndrewP16834946 please check if you are using MSOGenerateExcelFile to generate and download the excel. If yes please replace it with pxGenerateExcelFile. MSO is depreciated.

3

@AndrewP16834946

Please see this post:

pyData for pxGenerateExcelFile

and this post:

Values are not displaying in exported excel sheet in mail

If the file name and file type extension is.xlsm issues will occur. .xlsm files are macro files. Macros can not be saved to a non-macro Excel sheet. Please note the macros are being called through Excel by Pega so we can not change the way Excel stores macros. This is probably more likely an Excel question. As far as I understand with Excel, the macro is part of the file. You wouldn’t be able to execute a macro contained in another file

----> .xlsx is the one that is supported in pxGenerateExcelFile as per the below link:

Activities for integrating cases with Excel documents

The activity pxGenerateExcelFile only accepts two rows where one is the header and the other is the property reference.

If you have any additional rows then this errors are Expected. PxGenerateExcelFile is created for efficient performance. See archived support article.

also see the following resources

pxGenerateExcelFile generates file, but the file is not downloaded

[Video]: Tips for troubleshooting Export to Excel issues

Activities for integrating cases with Excel documents

For the latest Pega version:

Activities for integrating cases with Excel documents