Question
4
Replies
1196
Views
Infosys
Posted: October 9, 2015
Last activity: August 23, 2016
Closed
Solved
How do i parse data from excel where data in two or more sheets in excel
Hi,
I have requirement to read the data from excel and store in staging table. my problem here is data is stored in two sheets. how should I parse data from two sheets?
Pega 6 onwards includes Apache POI which allows you to read / write MS Excel files. Alternatively, you can also try JDBC drivers available to retrieve data from MS Excel.