Question
Accenture
IN
Last activity: 26 Jun 2024 8:41 EDT
How to download excel file configuration.
How to Download excel file configuration and what are the different ootb activity methods available to download and name the downloaded excel file.
Accepted Solution
Updated: 3 Jul 2024 9:21 EDT
Pegasystems Inc.
IN
@SudhaV17184692 - Can make use of pxGenerateExcelFile activity to download the file. Make use of open url in window action and pass this activity for generation of excel.
Thank you.
Updated: 26 Jun 2024 8:41 EDT
Eclatprime Digital Private Limited
IN
Please follow the below steps.
1) Excel sample file with required fields in specified syntax
Property name as heading in row 1
{.PageList().propertyname} in row 2
2) Create a binary file in technical (work type class)
Upload the sample file(Patientlistsample.xlsx) which we created, .xlsx,
3) Print the data in table format using a page list property as the source.
4) Button action - Open URL in window\
Enable use page
Activity: pxGenerateExcelFile
FSFileName - "Patientdata.xlsx"
TemplateRFB - excel!Patientlistsample!xlsx
DownloadFile - true
DeleteFileAfterDownload - true