JDBC Excel Metadata

Greenhorn

Posts: 1

posted 18 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

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

Rancher

Posts: 43081

posted 18 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

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.

Consider Paul's rocket mass heater.