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 reading from excel files Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


JavaRanch » Java Forums » Java » Java in General
Bookmark "reading from excel files" Watch "reading from excel files" New topic
Author

reading from excel files

S.L.Narayanan
Ranch Hand

Joined: Apr 01, 2005
Posts: 431
I have a excel file with a predefined name, location and column names. Now can I read the data from this excel file into my Java program. I just know the column name and I need to read all the rows of data. Number of rows will vary dynamically.


SCJP 1.4, SCWCD 1.4, SCBCD 1.3, NEXT--->IBM XML
Ulf Dittmer
Marshal

Joined: Mar 22, 2005
Posts: 42061
    
  64
There are a couple of libraries for accesing Excel files in Java. Check out the AccessingFileFormats page.
[ September 21, 2005: Message edited by: Ulf Dittmer ]

Ping & DNS - my free Android networking tools app
S.L.Narayanan
Ranch Hand

Joined: Apr 01, 2005
Posts: 431
Thanks Ulf. It is really helpful.
 
It is sorta covered in the JavaRanch Style Guide.
 
subject: reading from excel files