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****