File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
A friendly place for programming greenhorns!
Big Moose Saloon
Register / Login
JDBC Excel Metadata
Joined: Aug 19, 2006
Mar 27, 2007 01:30:00
How to get information about
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..
Joined: Mar 22, 2005
Mar 27, 2007 01:48:00
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:
subject: JDBC Excel Metadata
Excel Generation using POI
Accesing Excel data sheets through JDBC
How To compare two excel sheets using java
Generating an excel report from java by fetching the data from database.
All times are in JavaRanch time: GMT-6 in summer, GMT-7 in winter
| Powered by
Copyright © 1998-2014