How to download excel file configuration.

[SudhaV17184692 (Sudha V)]

How to Download excel file configuration and what are the different ootb activity methods available to download and name the downloaded excel file.

[Priyanka_Boga]

@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.

[Mamatha_Reddy_Mali (Mamatha Mali)]

Hi @SudhaV17184692

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