File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
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

Win a copy of REST with Spring (video course) this week in the Spring forum!
JavaRanch » Java Forums » Java » Java in General
Bookmark "Read an Excel file" Watch "Read an Excel file" New topic

Read an Excel file

Arun kartik Rajendran

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

Joined: Jan 03, 2004
Posts: 6109

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.

Ulf Dittmer

Joined: Mar 22, 2005
Posts: 42959
James Peterson wrote:

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.
Arun kartik Rajendran

Joined: Feb 28, 2013
Posts: 10
Thanks... I got it
I agree. Here's the link:
subject: Read an Excel file
It's not a secret anymore!