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 Read an Excel file Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Java » Java in General
Bookmark "Read an Excel file" Watch "Read an Excel file" New topic
Author

Read an Excel file

Arun kartik Rajendran
Greenhorn

Joined: Feb 28, 2013
Posts: 10
How to read an .xls file using java on column basis
Jeff Verdegan
Bartender

Joined: Jan 03, 2004
Posts: 6109
    
    6

As far as I know, Apache POI is still the defacto standard library for that sort of thing.

In the future, please SearchFirst.(←click) Thanks!
James X Peterson
Whizlabs Java Support
Ranch Hand

Joined: Feb 26, 2013
Posts: 158
Hi Arun kartik Rajendran,

Following link will help you.

http://mrbool.com/reading-excel-file-with-java/24562

Regards,
James
Ulf Dittmer
Marshal

Joined: Mar 22, 2005
Posts: 39547
    
  27
James Peterson wrote:http://mrbool.com/reading-excel-file-with-java/24562

It's not good practice to write POI code using the HSSF API at this point. The SS API encapsulates both HSSF and XSSF, and thus can handle both XLS and XLSX files - which is generally what you'd want to do.


Ping & DNS - updated with new look and Ping home screen widget
Arun kartik Rajendran
Greenhorn

Joined: Feb 28, 2013
Posts: 10
Thanks... I got it
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Read an Excel file
 
Similar Threads
I cannot delete a file.
Java.util.Properties Not Found During loading in Servlet/JSP Erro
File Creation
create file
To pass file object to webservice