Question

2
Replies
3568
Views
Close popover
Md Kousik (MdKousik)
Cognizant
Pega Lead System Architect
Cognizant
SE
MdKousik Member since 2015 26 posts
Cognizant
Posted: August 3, 2016
Last activity: August 16, 2016
Closed
Solved

How to export to excel with multiple tabs from different pagelists dynamically

Hi,

I have to export data in multiple tabs from pagelists dynamically. I was trying to follow below solution:https://mesh.pega.com/docs/DOC-89784

But It is giving error like problems during loading: Workbook settings.

Please find my below auto generated XML mapping.

please see attachment1

auto generated XML of the above XML:

<ns1:Workbook xmlns:ns1="urn:schemas-microsoft-com:office:spreadsheet">
<pega:withPage name="ExportToExcelPage.NodeNames"><ns1:WorkSheet Name="<pega:reference name=".pyNodeName" mode="normal"/>">
<ns1:Table>
<pega:withPage name="ExportToExcelPage.NodeNames.ApplicationNames.AgentList"><ns1:Row>
<pega:when java="<%= tools.findPage("ExportToExcelPage.NodeNames.ApplicationNames.AgentList") != null %>"><pega:withPage name="ExportToExcelPage.NodeNames.ApplicationNames.AgentList"><ns1:Cell>
<ns1:Data><pega:reference name=".LastExceptionData" mode="normal"/></ns1:Data>
</ns1:Cell></pega:withPage></pega:when>
</ns1:Row></pega:withPage>
</ns1:Table>
</ns1:WorkSheet></pega:withPage>
</ns1:Workbook>
 

As per the article, I have included above XML in another customised XML like below.

Please see attachment2.

Lastly I have done Property-set-XML and calling ExportToExcel activity.

Where is the problem? Please reply also if we have any other way to do this.

Thanks,

Kousik

Low-Code App Development Data Integration
Moderation Team has archived post,
Close popover This thread is closed to future replies. Content and links will no longer be updated. If you have the same/similar Question, please write a new Question.