Monday, 27 June 2022

Get PageList Exported to excel

 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 

No comments:

Post a Comment

Get PageList Exported to excel

  Get PageList Exported to excel 1. Create a Excel template as following format      A1: Column Name : Case ID       A2: Property Reference ...