wood burning stoves 2.0*
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 EJB 3 in Action this week in the EJB and other Java EE Technologies 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: 39547
    
  27
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 - updated with new look and Ping home screen widget
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: JDBC Excel Metadata
 
Similar Threads
cewolf charts
Excel Generation using POI
How To compare two excel sheets using java
Accesing Excel data sheets through JDBC
Generating an excel report from java by fetching the data from database.