File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
The moose likes Java in General and the fly likes Excel Reading Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login

Win a copy of RabbitMQ in Depth this week in the Open Source forum!
JavaRanch » Java Forums » Java » Java in General
Bookmark "Excel Reading" Watch "Excel Reading" New topic

Excel Reading

arun shivanna

Joined: Jul 09, 2003
Posts: 2
I have table in excel Sheet how to read from this xls file. please reply urgent
Joel McNary

Joined: Aug 20, 2001
Posts: 1824

Assuming that you are using Windows (and since you're using Excel...), set up an Excel ODBC pointing to your Excel file and then establish a connection through the JDBC-ODBC Bridge driver.

Piscis Babelis est parvus, flavus, et hiridicus, et est probabiliter insolitissima raritas in toto mundo.
Chris Treglio
Ranch Hand

Joined: Jun 18, 2001
Posts: 64
Joel's way is probably easier, but also consider Jakarta's POI project

With this you can read and write directly to the file, with no ODBC-JDBC.
I agree. Here's the link:
subject: Excel Reading