This week's book giveaway is in the Clojure forum.
We're giving away four copies of Clojure in Action and have Amit Rathore and Francis Avila on-line!
See this thread for details.
Win a copy of Clojure in Action this week in the Clojure forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

regarding excel sheet

 
Saral Saxena
Ranch Hand
Posts: 203
Eclipse IDE Java Oracle
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I have the requirement into which I have to take data from the excel sheet and then pump that data into the database , for ex there is a excel sheet containing two columns... and then I have to put the data of the two columns into the database into the particular table ...will Java help me and sply which libraries and how to do this ....please guide me ..!!Thanks
 
Paul Clapham
Sheriff
Pie
Posts: 20185
26
MySQL Database
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Apache POI is a library which will allow you to extract data from Excel documents.

As for updating a database, you would use JDBC. You will need to have a JDBC driver for your particular database in your classpath.
 
Praveen Kumar M K
Ranch Hand
Posts: 256
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
There is a SQL query for accomplishing the same. Syntax of the query might differ for different database engines.
 
Jesper de Jong
Java Cowboy
Saloon Keeper
Pie
Posts: 15150
31
Android IntelliJ IDE Java Scala Spring
  • 1
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
People regularly ask questions about how to read or write Excel files, so we have a page with some useful information about this: Accessing File Formats.
 
I agree. Here's the link: http://aspose.com/file-tools
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic