Close popover
Vipin Keshri (VipinK17)
Accenture LLP
Lead System Architect
Accenture LLP
VipinK17 Member since 2013 16 posts
Accenture LLP
Posted: July 31, 2019
Last activity: August 19, 2019

Does MSOGenerateExcelFile support nested pagelist to display grouped data

I'm able to use the MSOGenerateExcelFile to generate excel with pagelist data. i.e. i can load a table in excel using this pagelist property.

The requirement is to be able to display multiple tables or multiple list with group header.

For e.g.

First display claim details for Patient 1 with heading of patient name

Then second patient claims with Patient name in header and so on.. we do not want to hardcode patient #.

Patient Name: ABC (.patient(1).name)

Claim No (.patient(1).claim().ClaimNumber) , Amount (.patient(1).claim().Amount)

C1, 453.00

C2, 451.00

Patient Name: DEF (.patient(2).name)

Claim No (.patient(2).claim().ClaimNumber) , Amount (.patient(2).claim().Amount)

C1, 73.00

C2, 51.00

C3, 10.00

If supported, how do we format the template to achieve this? Really thanks in advance!

***Edited by Moderator Marissa to update platform capability tags****

Pega Platform Low-Code App Development Data Integration Java and Activities
Moderation Team has archived post