This week's book giveaway is in the Servlets forum.
We're giving away four copies of Murach's Java Servlets and JSP and have Joel Murach on-line!
See this thread for details.
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 Murach's Java Servlets and JSP this week in the Servlets 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: 41076
    
  43
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
 
Similar Threads
cewolf charts
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.
Excel Generation using POI