aspose file tools*
The moose likes JDBC 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 Spring in Action this week in the Spring forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "JDBC Excel Metadata" Watch "JDBC Excel Metadata" New topic
Author

JDBC Excel Metadata

S.Shahbaz Ali
Greenhorn

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
Marshal

Joined: Mar 22, 2005
Posts: 42289
    
  64
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.


Ping & DNS - my free Android networking tools app
 
 
subject: JDBC Excel Metadata