Question
Sandlands
AU
Last activity: 7 Jul 2023 13:30 EDT
Facing issues in downloading excel file
Hi,
We upgraded our application from 7.4 to 8.5.
But excel file is not exporting.
Please help me in this scenario.
Thanks
Accepted Solution
Updated: 7 Jul 2023 13:30 EDT
Pegasystems Inc.
GB
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
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
Bits in Glass
IN
@AndrewP16834946 please check if you are using MSOGenerateExcelFile to generate and download the excel. If yes please replace it with pxGenerateExcelFile. MSO is depreciated.
Accepted Solution
Updated: 7 Jul 2023 13:30 EDT
Pegasystems Inc.
GB
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
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