How to Export datapage data to excel..?
I mean i am using a repeatinggrid in section for that i have given datapage as source so i need to export all the rows into a excel file on clicking of a button.
Can you please give some solution for this..!!!!
Thanks in advance :)
***Moderator Edit: Vidyaranjan | Updated Categories***
Capgemini
IN
You can use MSOGenerateExcelFile OOTB activity to generate excel. This activity takes one binary excel template containing the property and header details as input.
-Saikat
Pegasystems Inc.
IN
Can you please give me the structure how we have to specify in excel template..!!! Like for pagelist we will specify like pagelist().property
Virtusa Consulting UK
GB
This is how you should provide the parameters for the excel template.
{.pagelist().proprety input}
Please let me know if you need any other information.
Pegasystems Inc.
IN
Yeah KAUTUKSHET actually that is to get data from pagelist but my question is i have given source as dpage for repeating grid so i need to export all those records into excel..!!
So to fetch from dpage in excel template how we have to give..?
Aaseya IT Services
AU
Hi,
You can use 2 methods to achieve this.
1. You can create a temp pagelist and copy D_PageList.pxResults values to tempPageList.pxResults using page-copy
and then use page list template and call MSOGenerateExcelFile activity.
2. You can use pxConvertResultsToCSV activity and pass parameters to this activity( No need of any Template for this activity.)
Please find the below screenshots for reference for both the methods. Hope this helps.
Thanks
Pegasystems Inc.
IN
Yeah thank you HarishAkula,it is working fine when i run my activity directly but when i try to call that activity on a button file is not downloading whats the problem..?
Aaseya IT Services
AU
Hi Vinay,
It is working fine for me for both the methods and even I checked in different browsers to check if any browser compatibility but it is working fine. Please refer below screen shot and let me know if you face any issue.
Thanks