Question
Capgemini
IN
Last activity: 4 Jan 2023 5:46 EST
Export To Excel is Not working
Hello,
We are upgrading application from 7.3 to 8.6 and ootb export to excel is not working from anywhere.
If anyone has faced this earlier, Please help.
Accepted Solution
Updated: 4 Jan 2023 5:46 EST
T- Systems ICT Private Limited
IN
@Alakananda , In activity Use pxGenerateExcel method and pass the parameters. I hope it will helps you for the Export to Excel.
Pegasystems Inc.
GB
@Alakananda please can you clarify the configuration you are using and symptoms you are experiencing?
Are you using MSOGenerateExcelFile? Can you use pxGenerateExcelFile?
Did you already check other forum questions ?
PEGA 8.1.2: OOB Report definition export to excel not working
Export To Excel is not Working in PEGA 8.3
Export to excel functionality not working
Excel formatting issue-Number in this cell is formatted as text or preceed by an apostrophe
Column Format not retaining in Export to Excel within a Report Definition
@Alakananda please can you clarify the configuration you are using and symptoms you are experiencing?
Are you using MSOGenerateExcelFile? Can you use pxGenerateExcelFile?
Did you already check other forum questions ?
PEGA 8.1.2: OOB Report definition export to excel not working
Export To Excel is not Working in PEGA 8.3
Export to excel functionality not working
Excel formatting issue-Number in this cell is formatted as text or preceed by an apostrophe
Column Format not retaining in Export to Excel within a Report Definition
Generating Excel with Images at desired position is feasible?
We try to discourage Pega designers from calling the activity responsible for doing Export To Excel as this causes various problems. The only supported way to use Export to Excel is by using the Export to Excel option on Report Definitions.
Please could you follow the post How to format excel file and style according to requirement?
This link is related to excel export from Report Definition.
For an example on the use of a Template (Binary File) see this post.
The main documentation on what is, and what is not possible with pxGenerateExcelFile is in Activities for integrating cases with Excel documents
See the table in the document which lists features that Pega Platform supports when generating Excel files with the pxGenerateExcelFile activity.
Please check the articles I have highlighted above. If these do not solve your issue, please clarify the problem.
Capgemini
IN
Hi,
We are trying to export to excel from report definition rule.
By updating the user action option in report viewer tab.
Updated: 4 Jan 2023 5:45 EST
Pegasystems Inc.
GB
@Alakananda this does not sound OOTB.
Please check the links I listed.
Capgemini
IN
Hello
We have run this query
update PegaRULES.pr_engineclasses set pzcodeset='pega-enginecodenouse' where PegaRULES.pr_engineclasses.pzjar like '%serializer%' or PegaRULES.pr_engineclasses.pzjar like '%xalan%'; commit;
and restarted the server.
Did not work in our case.
Accenture
GB
@AlakanandaHi, Greetings. I have tested this on 8.6 and 8.7, i can export the results to excel as well as pdf. Do you see any errors in logs or in console of Browser?
Regards,
Bharat
T- Systems ICT Private Limited
IN
Hi @Alakananda, Which method have you called in the 7.3 Version.May I know?
Capgemini
IN
@Kamineni Surya In 7.3 also we are using the user action option for export to excel in RD rule and it is working fine. in 8.6 it is not working.
We have run this query
update PegaRULES.pr_engineclasses set pzcodeset='pega-enginecodenouse' where PegaRULES.pr_engineclasses.pzjar like '%serializer%' or PegaRULES.pr_engineclasses.pzjar like '%xalan%'; commit;
Did not work for our case.
Do we need to restart the Jboss or tomcat for these to take effect?
Accepted Solution
Updated: 4 Jan 2023 5:46 EST
T- Systems ICT Private Limited
IN
@Alakananda , In activity Use pxGenerateExcel method and pass the parameters. I hope it will helps you for the Export to Excel.