• Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

How to read Excel in Java application

 
Senthilkumar Adaickalam
Greenhorn
Posts: 14
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi,

I need to read the Excel sheet and send all the data to the database. I had tried with examples from the net but couldnt able to solve it. The Excel Sheet is having around 50+ rows and having 5-10 uneven columns spread over the rows.

For ex, the rows looks like,
Company Name:--------------- Year Established:---------------
Address:--------------------------- Ownership: Public--------
City------------------------------------- State---------------------- Private-------
Country------------------------------- Website----------------- Other-------

The value of Owenership should be either public or private or other.

How do I read this XL and put the data into the database?

Thanks in Advance
Senthil
 
Srinivasa Raghavan
Ranch Hand
Posts: 1228
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
In this case Excel can be assumed as a DB & connect to Excel using JDBc & transfer you records ..
Yon even search goole for stuffs like POI by jakarta..
 
Fisher Daniel
Ranch Hand
Posts: 582
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi,
You can get more information about what you want in Jakarta POI

Hope this help
daniel
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic