Question

2
Replies
3460
Views
MdKousik Member since 2015 26 posts
Cognizant
Posted: 4 years ago
Last activity: 4 years 2 months ago
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
Share this page LinkedIn