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
**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.
MSOParseExcelFile works with multiple tabs as well and we were able to read the data in all the sheets. You can provide the input excel sheet template with multiple tabs in the same order as original sheet.
Keep up to date on this post and subscribe to comments