It's not a secret anymore!
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
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
It's not a secret anymore!