How to use MSOGenerateExcelFile Activity to download data which is on a Page and PageList (pxResults) ?
Below is the example of clipboard structure
workpage.Pega.Page.pylabel ----Excel
workpage.Pega.PageList(1).pynote - 123
workpage.Pega.PageList(2).pynote - 234
workpage.Pega.PageList(3).pynote - 345
workpage.Pega.PageList(4).pynote - 456
---------------------------------------------------------------------
Binary file Template
A B
workpage.Pega.PageList().pynote workpage.Pega.Page.pylabel
--------------------------------------------------------------------------
If i use MSOGenerateExcelFile Activity below is the output on excel file.
A B
1) 123 Excel
2) 234 Excel
3) 345 Excel
4) 456 Excel
---------------------------------------------------------------------------------
As per requirement downloading excel should contain values as shown below.
A B
1) 123 Excel
2) 234
3) 345
4) 456
any solutions for the requirement.
I will be grateful for any help you can provide for our requirement.
***Edited by Moderator: Lochan to update platform capability tags***
Pegasystems Inc.
IN
PageList properties:
{.pyExcelUseCases().pyInput input}
Page Properties:
{.pyPage.pyLabel input}
For more information please find the attached xlsx file