Question
4
Replies
2574
Views
Posted: December 28, 2015
Last activity: February 16, 2016
Closed
Solved
Can we parse excel file with multiple tabs/sheets?
We have a requirement to parse excel file which has multiple tabs/sheets in an excel which comes as an attachment from SOAP/REST Service.
So can we use MSOParseExcelFile activity to parse such an excel? Is there a way to meet such a requirement without any customization.
Also we have to create a similar excel file with updated data and pass it on to downstream systems within PEGA.
Any help in this regard will be highly appreciated.
Note: We are using PEGA v7.1.8
Hi,
Have you tried using OOB MSOParseExcelFile method? This take in parameter:
FSFFileName : Name and Location of the uploaded excel file.
TemplateRFB: Name of the uploaded binary file, it should follow <Directory name>!<Rule Name>!<extension>
MSOParseExcelFile method only reads .xls files.
https://pdn.pega.com/support-articles/unable-read-data-excel-sheet-when-file-type-xls
MSOPaseExcelFile method is implemented using Apache POI jar, you want to check if there is any API to suffice your use case to parse multiple tabs/sheet:
Apache POI - the Java API for Microsoft Documents