JDBC Excel Metadata

[S.Shahbaz Ali]

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]

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.