Question

7
Replies
1167
Views
 Sarath Prashanth (SarathPrashanth)
CAPGEMINI
Senior Application Consultant
CAPGEMINI
SE
SarathPrashanth Member since 2016 52 posts
CAPGEMINI
Posted: April 2, 2018
Last activity: August 22, 2019
Posted: 2 Apr 2018 5:51 EDT
Last activity: 22 Aug 2019 6:08 EDT
Closed
Solved

Exporting data into Multiple excel Sheets

Hi All,

Is there any OOTB feature which helps me in exporting data into multiple sheets.

MSOGenerateExcelFile will generate whole set of data into a single sheet. But i want certain data to be in sheet 2 some in sheet 1.

Is this possible. Kindly let me know your thoughts on this.

-Sarath

Low-Code App Development 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.
Posted: 3 years ago
Posted: 2 Apr 2018 10:37 EDT
Rajasekar K M (Rajasekar K M)
OCBC Bank
Developer
OCBC Bank
SG

Hello Sarath,


Could you please eloborate your requirement. I mean how you are segregating the data and exporting it as excels. Is that you are not able to generate those specific data in another step page and run the OOTB activity in the context of the latter page.


Best regards,


Rajasekar.
Posted: 3 years ago
Posted: 3 Apr 2018 7:02 EDT
Sarath Prashanth (SarathPrashanth)
CAPGEMINI
Senior Application Consultant
CAPGEMINI
SE

Hi Rajasekar, 


Lets say i have a page list which have some details like name, Mobile, Email and Policy details. 


In one sheet i want CustID (Unique Key) , Name, Mobile, Email 


And in Another sheet CustID, Policy Details, Requested date . 


So a single excel file with two separate sheets has to be downloaded. 


In MSOGenerateExcel - Will put all those details in a single sheet and downloads it. 
Posted: 2 years ago
Posted: 28 Mar 2019 7:01 EDT
Dinesh Reddy (DineshReddyMeka)
LTI
System Achitect
LTI
IN

In binary file add the second sheet and give the template details i.e clipboard pagelist eg.{.pageList().property input}. 


In the activity may sure that we have the properties in the pagelist.


To download pagelist content in single excel sheet  please find the link below.


https://community1.pega.com/community/pega-support/question/there-way-export-pagelist-contents-pdf-pega-73


 


 


 
Posted: 1 year ago
Posted: 22 Aug 2019 6:08 EDT
Vidyaranjan AV (Vidyaranjan)
MOD
Senior Online Community Moderator
Pegasystems Inc.
IN

Hi @PARSURAMP -


Thank you for posting your query in the PSC. This looks like an inactive post and hence, we suggest you create a new post for your query with detailed description of the issue.


Click on the Write Post button here. Once created, please reply back here with the URL of the new post.


You may also refer this discussion link as a reference in the new thread.


If this was a test post, please go ahead with deleting the post from your end or letting us know. We can do it for you.


Thanks.