Discussion

How to import details present in a page list to csv file

Hi All,

We have a requirement in our project to import the details present in the embedded pages to a csv file. Do we have any OOTB method or Java code for implementing this.....Any help is appreciated.

**Moderation Team has archived post**

This post has been archived for educational purposes. Contents and links will no longer be updated. If you have the same/similar question, please write a new post.

Comments

Keep up to date on this post and subscribe to comments

August 12, 2014 - 5:52am

MSOGenerateExcelFile OOTB activity - Which will get template name as parameter. u can check the referencing rules.

December 15, 2014 - 1:47pm

Store the pagelist data in a local string variable and then customize AttachtoWork (code-attach-pdf) activity accordingly.

June 25, 2015 - 5:25am

You  can use OOTB activity ExportToExcel by passing pyFileData parameter

 

Create an HTML Stream rule with below code

<html>
<body>

<table border="1">
<tr>
<th>Customer ID</th>
<th>Acct No #</th>
<th>FirstName</th>
<th>Last Name</th>
<th>Address</th>
<th> City#</th>
<th>State</th>
</tr>

 

<pega:forEach name="PagelistPage.pxResults">
<pega:withEmbedded name="$THIS">
<tr>

<%
  String ID= tools.getStepPage().getString("CustomerID");
  tools.appendString("<td wrap>" + ID + "</td>");

-------

include for all the properties u want to see in excel

----------

%>
</tr>
</pega:withEmbedded>

</pega:forEach>
</table>
</body>
</html>

Create an activity

 step 1) property-set-HTML

Param.pyFileData = HTML Stream rule name (create in above step)

 step 2) call ExportToExcel activity with passcurrent page parameter checked.

 

You can able to view the pagelist information into the excel