This week's book giveaway is in the Clojure forum.
We're giving away four copies of Clojure in Action and have Amit Rathore and Francis Avila on-line!
See this thread for details.
Win a copy of Clojure in Action this week in the Clojure forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

JDBC Excel Metadata

 
S.Shahbaz Ali
Greenhorn
Posts: 1
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Pie
Posts: 42966
73
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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.
 
I agree. Here's the link: http://aspose.com/file-tools
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic