Question
4
Replies
1185
Views
Infosys
Posted: October 9, 2015
Last activity: August 23, 2016
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?
Accepted Solution
Posted: 5 years ago
Posted: 4 years ago
Hi Rajiv ,
Could you please elaborate this scenario with steps.
Posted: 4 years ago
Sorry, I seemed to have missed this question. Which of the two approaches are you looking for steps?
This is a good place to start of JDBC - Excel JDBC Driver download | SourceForge.net
This is a good start for reading Excel using Apache POI - http://viralpatel.net/blogs/java-read-write-excel-file-apache-poi/
Posted: 4 years ago
How to read all the columns of the excel sheet which is generated as an email attachment and store the data in a table
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.