Question4Replies2574Views×Close popoverPrasad Yoganarasimha (Prasad_BY) UnitedHealth Group Senior Software Engineer UnitedHealth Group US View Profile Prasad_BY Member since 2014 12 posts UnitedHealth Group Posted: December 28, 2015Last activity: February 16, 2016Posted: 28 Dec 2015 8:34 ESTLast activity: 16 Feb 2016 9:35 EST 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 Pega Customer Service Data Integration Low-Code App Development ×Close popoverFacebookTwitterLinkedinEmail Copy Link Copied! Moderation Team has archived post 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. Posted: 5 years agoUpdated: 5 years agoPosted: 30 Dec 2015 11:55 ESTUpdated: 30 Dec 2015 12:02 EST×Close popoverSirohi (AdityaSirohi930765655) View ProfileAdityaSirohi930765655 replied to Prasad_BYHi,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-xlsMSOPaseExcelFile 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 Posted: 5 years agoPosted: 8 Jan 2016 1:48 EST×Close popoverPrasad Yoganarasimha (Prasad_BY) UnitedHealth Group Senior Software Engineer UnitedHealth Group US View ProfilePrasad_BY UnitedHealth Group replied to AdityaSirohi930765655Hi Aditya,Does MSOParseExcelFile support multiple tabs in an excel.I know it works when we have one sheet. If it does not, worst case we are planning to use Apache POI APIs using custom java.Regards,Prasad Accepted Solution Posted: 4 years agoPosted: 16 Feb 2016 9:15 EST×Close popoverNikhilesh NVS (NikhileshN) TCS TCS JP View ProfileNikhileshN TCS replied to Prasad_BYMSOParseExcelFile 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. Posted: 4 years agoPosted: 16 Feb 2016 9:35 EST×Close popoverPrasad Yoganarasimha (Prasad_BY) UnitedHealth Group Senior Software Engineer UnitedHealth Group US View ProfilePrasad_BY UnitedHealth Group replied to NikhileshNThanks Nikhilesh.