Skip to main content

This content is closed to future replies and is no longer being maintained or updated.
Links may no longer function. If you have a similar request, please write a new post.

Question

 Subramanyam Reddy Kummithi (srkummithi)
Infosys
Lead System Architect
Infosys
US
srkummithi Member since 2012 3 posts
Infosys
Posted: Oct 9, 2015
Last activity: Aug 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?

To see attachments, please log in.
Data Integration

Accepted Solution

Posted: 9 years ago
Posted: 9 Oct 2015 1:41 EDT
Rajiv Nistala (nistr) 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.

To see attachments, please log in.
Posted: 8 years ago
Posted: 22 Mar 2016 1:50 EDT
Rajiv Nistala (nistr) 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/

To see attachments, please log in.

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