Question
TMHCC
GB
Last activity: 21 Feb 2017 10:55 EST
How to populate Pagelist Values into Excel sheet template(using MSOGenerateExcelSheet)
Please refer the attachments.(discard pyWorkpage in the Rule file Binary if your context is already pyWorkPage)
If it is single Property Just refer the property directly without any ().
***Updated by moderator: Lochan to update Categories***
Thanks,
Harika Boddu
Pegasystems Inc.
IN
Hi,
Probably, you need to make a call to MSOGenereateExcelFile and pass the parameter 'TemplateRFB' appropriately
Before that you need to create Rule-File-Binary , and upload the excel sheet, with appropriate syntax as :
Infosys
NL
You can use OOTB activity MSOGenerateExcelFile. Call this activity keeping your pagelist (or data page ) as step page. It takes three parameters, 1. FSFileName - Name of the excel created, 2. TemplateRFB - Template name (format : "excel!TemplateName!xlsx") , 3. DownLoadFile - true/false. Prior to using this activity, create a template excel file and define the column header and property reference for column value. Create a binary file in PRPC and upload this excel. This template excel will have the details of the properties you want to send to the output excel and its name is required for the second parameter.
Let me know if you need any other details.
Thanks
Sumit
CVS
US
Hi Sumit-
I have very similar scenario. Except there is another page list in the first page list. Is there a way to display the properties under 2nd page list into the excel sheet?
If I give in the below format, it is not working:
{.Testpl().ExportAttributeVGP() input}
-Thank you so much in advance
Prathima
This comment has been branched out as a new node and the new thread can be followed here
Pegasystems Inc.
IN
Hi Prathima,
You have replied to an older thread which lacks activity. To gather better visibility for your question, I have branched it to create a new question. You may continue your conversation on this thread: How to populate Pagelist Values into Excel sheet template
Hi Prathima,
You have replied to an older thread which lacks activity. To gather better visibility for your question, I have branched it to create a new question. You may continue your conversation on this thread: How to populate Pagelist Values into Excel sheet template
Hope the information is helpful.
Thanks!