wood burning stoves 2.0*
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 Android Security Essentials Live Lessons this week in the Android 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: 1817

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.
jQuery in Action, 2nd edition
subject: Excel Reading
Similar Threads
OutOfMemory error
WA #1.....word association
Problem in retrieving Cell values from Excel file.
Record Export?
JasperReports -- excel issue