Skip to main content
Contact a Moderator

Question

4
Replies
1246
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: 6 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: 6 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: 5 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

We'd prefer it if you saw us at our best.

Pega Collaboration Center has detected you are using a browser which may prevent you from experiencing the site as intended. To improve your experience, please update your browser.

Close Deprecation Notice