Skip to main content

This content is closed to future replies and is no longer being maintained or updated.
Links may no longer function. If you have a similar request, please write a new post.

Question

 Aakash Talreja (Aakash@13)
Personal

Personal
IN
Aakash@13 Member since 2017 10 posts
Personal
Posted: Mar 24, 2018
Last activity: Mar 26, 2018
Posted: 24 Mar 2018 16:06 EDT
Last activity: 26 Mar 2018 3:07 EDT
Closed

Activity for Exporting data to excel file

Hello,

I have a requirement to Export the data to Excel,i have written one activity with "Call Rule-Obj-Report-Definition.pxRetrieveReportData" to retrieve values from report definition to which i passed ReportName and className and the second method is "Call pzViewExportToExcel " to which PageName.pyReportDefinition passed as step page and this activity working fine for pega version 7.2 but when i tried to replicate in pega version 7.3 the second method "Call pzViewExportToExcel " is throwing error(No such method defined) is there any alternative to this i tried ExportToExcel method also that too didn't worked.

Any suggestion of where i am going wrong or any other alternative to the second method describe.

Regards,
Aakash Talreja

To see attachments, please log in.
Reporting

Posted: 6 years ago
Posted: 24 Mar 2018 19:00 EDT
Mohammad Asif Hasan (Mohammad_Asif_Hasan)
EPAM Systems, Inc.
Mohammad Asif Hasan
EPAM Systems, Inc.
ES
Hi, Thanks for posting on PSC. Going forward from 7.3 version, We have new implementation to download Excel data in XLSX format instead XSL format. You could use an OOTB activity "MSOGenerateExcelFile" for the same. Refer this link, it has detailed implementation with example (Outside Pega network) https://krishnapega.blogspot.in/2016/05/how-to-generate-excel-and-send-mail.html?m=1 Hope it helps, kindly notify if it does by marking this post as answered. Regards, Asif
To see attachments, please log in.
Posted: 6 years ago
Posted: 24 Mar 2018 19:02 EDT
Mohammad Asif Hasan (Mohammad_Asif_Hasan)
EPAM Systems, Inc.
Mohammad Asif Hasan
EPAM Systems, Inc.
ES
Additionally, I have found below links which could be referred to understand more. - https://pdn.pega.com/community/product-support/question/how-msogenerateexcelfile-works - Probable issue, if at all https://collaborate.pega.com/discussion/exercise-change-business-rules-how-save-changed-business-rule-revision
To see attachments, please log in.

We'd prefer it if you saw us at our best.

Pega Collaboration Center has detected you are using a browser which may prevent you from experiencing the site as intended. To improve your experience, please update your browser.

Close Deprecation Notice