The moose likes JDBC and Relational Databases and the fly likes JDBC Excel Metadata Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login

Win a copy of Make it so: Java DB Connections & Transactions this week in the JDBC forum!
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "JDBC Excel Metadata" Watch "JDBC Excel Metadata" New topic

JDBC Excel Metadata

S.Shahbaz Ali

Joined: Aug 19, 2006
Posts: 1
How to get information about Excel Sheets from an excel fine?
I want to know names of Excel sheets.. I am using JDBC-ODBC to do this.
any help would be appreciated..
Ulf Dittmer

Joined: Mar 22, 2005
Posts: 42959
You might play around with the DatabaseMetaData that youc an retrieve through the Connection object, but I'm not sure you'll get anywhere with that. Excel files are just not a relational database.

You could also use a library like Jakarta POI to read the Excel file.
I agree. Here's the link:
subject: JDBC Excel Metadata
jQuery in Action, 3rd edition