Question

4
Replies
1211
Views
 Subramanyam Reddy Kummithi (srkummithi)
Infosys
Lead System Architect
Infosys
US
srkummithi Member since 2012 3 posts
Infosys
Posted: October 9, 2015
Last activity: August 23, 2016
Posted: 9 Oct 2015 0:23 EDT
Last activity: 23 Aug 2016 2:35 EDT
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?

Data Integration
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.

Accepted Solution

Posted: 5 years ago
Posted: 9 Oct 2015 1:41 EDT
Rajiv Nistala (nistr)
PEGA
Senior Manager - Engineering
Pegasystems
IN

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.
Posted: 5 years ago
Posted: 22 Mar 2016 1:50 EDT
Rajiv Nistala (nistr)
PEGA
Senior Manager - Engineering
Pegasystems
IN

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
Posted: 23 Aug 2016 2:35 EDT
Prashanth Nair Prabha Kumar (nairp2)
PEGA
Systems Engineer - Cloud
Pegasystems Inc.
IN

How to read all the columns of the excel sheet which is generated as an email attachment and store the data in a table