Question

2
Replies
1292
Views
Vikram Reddy (Vikram22)
TechMahindra

TechMahindra
IN
Vikram22 Member since 2014 28 posts
TechMahindra
Posted: June 5, 2019
Last activity: June 20, 2019
Posted: 5 Jun 2019 21:44 EDT
Last activity: 20 Jun 2019 3:26 EDT
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, 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.