What are you exporting to Excel? A Report, a Data Table, or a Decision Table?  Are you doing this within Designer Studio (the Developer Portal) or from the Case Manager Portal?  Please elaborate on your use case.

Regards,

Henry

Pega Academy

What version of Pega/PRPC are you using? Also, where is this button. Is it part of the requirements/specifications export to excel?

Thanks,

Bill Rathert

I am using Pega 6.2 SP2 and am trying to export report data from a Listview using the default Export To Excel button.

Hi Manash,

After clicking on the "Export to Excel" icon in the toolbar of the Report Viewer you are prompted with a "File Download" modal dialog box that asks, "Do you want to open or save this file?".  Simply click the "Save" button on this modal dialog box and the "Save As" window then opens.  Simply change the "File name:" field from "ExportData.xls" to use whatever name you would like for the new spreadsheet.

Regards,

Henry

Pega Academy

Manash,

You can set the file name dynamically using a property. Take a look at this article: https://pdn.pega.com/reporting/how-to-produce-pdf-reports-on-a-nightly-schedule

Also, here is a forum post that might prove helpful:

https://pdn.pega.com/forums/connect-file/can-file-names-in-connect-file-rules-be-parameterized-dynamically

eddie

Thanks a lot for your assistance

An activity pzViewExcelData has fixed filename,ExportData.xls as a MIME header context (ContentDisposition: attachment;filename=ExportData.xls).

The reference seems only for PDF, but need Excel solution same as PDF.

Unless that, need to change pzViewExcelData java code, I guess. Am I right?