File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
The moose likes Java in General and the fly likes Get Sheet name dynamically from a MS-Excel file Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Spring in Action this week in the Spring forum!
JavaRanch » Java Forums » Java » Java in General
Bookmark "Get Sheet name dynamically from a MS-Excel file" Watch "Get Sheet name dynamically from a MS-Excel file" New topic
Author

Get Sheet name dynamically from a MS-Excel file

Mohan Ganesan
Greenhorn

Joined: Nov 22, 2003
Posts: 18
Hi,
I want to get all the sheet name from a ms-excel file dynamically using java and JDBC connection. I can get the excel values but now i am hard coded the sheet name. Instead of that i have to get the sheet name dynamically by passing the file name or path. Please help me out from this query. Thanks

Mohan
Tausif Khanooni
Ranch Hand

Joined: Nov 14, 2002
Posts: 107
hi
u can just go thru the api's provided by jakarta to read and write
the ms-xl files. this api is called POI(I think...)

luck!


"Walking on water and building IT Architecture from <br />specification are easy if and only if both are frozen"
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Get Sheet name dynamically from a MS-Excel file