PEGADiary: June 2022

Monday, 27 June 2022

Get PageList Exported to excel

1. Create a Excel template as following format

A1: Column Name : Case ID

A2: Property Reference as : {ExcelPage.pxResults().CaseID} // inside {}

2. upload it as a Binary file in excel format

“excel” as the App name

File type extention as xlsx

3. Call pxGenerateExcelFile and keep primary page as the PageList which need to be exported

define a file name "Exported.xlsx"

define the template name as "excel!<FILENAME>!xlsx"

4. add the action set in the button as "open URL in Window" and define the activity name

pega.u.d.setProperty("PageName.Property","Value");

<html>

<body>

function SetPropertyValue(){

var v1 = document.GetElementByID("PropertyName").Value;

pega.u.d.setProperty("PageName.PropertyName","v1");

</body>

</html>