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
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: 41499
    
  53
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
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: JDBC Excel Metadata