Discussion


Cognizant Technology Solutions
IN
Last activity: 24 Jun 2021 1:24 EDT
How to get the data from a case into a excel sheet in pega
We can get the data from a case and set into a excel sheet. To do this refer the attached document.
***Updated by moderator: Lochan to mark post as Discussion; add group tag***
-
Reply
-
hanumantha kosuri Pradip Kavade -
Share this page Facebook Twitter LinkedIn Email Copying... Copied!


Cognizant India Pvt. Ltd
IN
Hi Pratik,
Thanks a lot for the information. I just got a similar requirement and this document helped me a lot.


COFORGE
GB
Hi Pratik,
can the same be achieved for a repeating list?
Thanks in advance


Cognizant Technology Solutions
IN
Hi Jibran,
Yes it can be done for the repeating list in that case we use the activity for a page list instead of a page.
Thanks,
Pratik.


Pegasystems Inc.
IN
Hi Pratik,
Thank you for sharing this procedure on our community. We appreciate your effort and interest to contribute to the Pega knowledgebase.
Regards,


Aaseya IT Services
GB
Hi Jibran,
You can follow below screenshots for pagelist concept.
Note: You can use page copy and add PageListProperty.pxResults(<APPEND>) into CopyInto field and make sure you remove Temp Page by using page remove in the first step to avoid previous values.
Regards,
Harish


BNYMellon Technology
IN
Hi Prathik
Thank You for your efforts. Appreciate it. I question, Can we load data into multiple tabs? Pls guide


BNYMellon Technology
IN
I am able to acheive this by modifying the template with different tabs and referring properties appropriately. Thanks a lot Pratik.


KLUniversity
IN
@Pratik_Agarwal hi sir
when i trying the same scenario im facing the below error sir.
"Failed to open Rule-File-Binary with Application Name = excel, File Name = MyExcelSheet and File Type = xlsm"
Please help me with it


Bank Of America
IN
@RAMYA REDDYV please check if your naming convention when passing the excel template to the MSOGenerateExcel Activity.