aspose file tools*
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
Author

Excel Reading

arun shivanna
Greenhorn

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

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

http://jakarta.apache.org/poi/index.html

With this you can read and write directly to the file, with no ODBC-JDBC.
 
jQuery in Action, 2nd edition
 
subject: Excel Reading