File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
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
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: 42965
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
It's not a secret anymore!