Guide to generate excel in pega

The Case Type :

The the generate excel is Present in DataExport section:

we need to create a Template and the functionality to be able to select our sales data and export the seleted sales data 

The Get Sales Data Section;

Lets Open the sales Data section

The Selection logic is present in the select column inside the checkbox action

The action tab has a activity lets look at it 

Lets see the activity

The Pages and classes tab

Now that our logic is in places lets open the DataExport section and check the generate excel part

Lets See the action tab of generate excel 

The tempalate is SalesData as you can see it in the parameter TemplateRFB(excel!SalesData!xlsx)

Lets open the Binary file to get the excel template where to get the template 
Records –> Technical –> Binary File

label: SalesData

AppNameL:excel

File Type : xlsx

sample Template : provided free in below link 

Download Sample Template ==>  click here

once you are getting the Happy path you will get the details as below 

Thanks For Reading 

Happy Learning