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.
I followed your steps and was able to export the pagelist elements to an excel. However, the download is happening only for one time. If I try to click the button (where the activity is configured)for the second time then the export download is not happening.
Please suggest if any other configurations are to be followed.
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. 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.
This is a known issue at Pega side. After the refresh section download, the browser couldn't identify the second time refresh download as a new event. Please perform a run script action on your click action instead of Refresh section. Below is the code for the run script function. You can add this in userworkform or JS file if have any in your application.
Passed the activity name you created for downloading the file and pass the file name and template name in the parameters while providing this function in run script
You can aslo use OOTB activity pzMSOGenerateExcelAndSaveToWorkFileAttachment for generating the excel file.It will store the excel file content in TempDataWorkAttachFile.pyAttachStream in base64 format.
Step-1 -- As mentioned by Sumit create a binary file and upload the excel template.
Step-2 -- Call pzMSOGenerateExcelAndSaveToWorkFileAttachment activity by giving the parameter keysSourceRFB- Template name (format : "excel!TemplateName!xlsx").
Step-3 -- Create an AttachmentPage(Embed-EmailAttachment) with the following data and send this AttachmentPage as parameter for the SendEmailNotification Activity.