Question

2
Replies
1223
Views
Close popover
Vikram Reddy (Vikram22)
TechMahindra

TechMahindra
IN
Vikram22 Member since 2014 25 posts
TechMahindra
Posted: June 5, 2019
Last activity: June 20, 2019
Closed

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

Data Integration Java and Activities
Moderation Team has archived post,
Close popover This thread is closed to future replies. Content and links will no longer be updated. If you have the same/similar Question, please write a new Question.