This week's giveaway is in the EJB and other Java EE Technologies forum.
We're giving away four copies of EJB 3 in Action and have Debu Panda, Reza Rahman, Ryan Cuprak, and Michael Remijan on-line!
See this thread for details.
The moose likes Java in General and the fly likes regarding excel sheet Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login

Win a copy of EJB 3 in Action this week in the EJB and other Java EE Technologies forum!
JavaRanch » Java Forums » Java » Java in General
Bookmark "regarding excel sheet" Watch "regarding excel sheet" New topic

regarding excel sheet

Saral Saxena
Ranch Hand

Joined: Apr 22, 2011
Posts: 202

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

Joined: Oct 14, 2005
Posts: 18113

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

Joined: Jul 03, 2011
Posts: 256
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

Joined: Aug 16, 2005
Posts: 13868

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.

Java Beginners FAQ - JavaRanch SCJP FAQ - The Java Tutorial - Java SE 7 API documentation
Scala Notes - My blog about Scala
I agree. Here's the link:
subject: regarding excel sheet
Similar Threads
Excel Related
Excel Related
Oracle 9i to Excel Sheet
Write Data to Excel
Copy particular rows in excel using POI