This week's book giveaway is in the Jobs Discussion forum.
We're giving away four copies of Java Interview Guide and have Anthony DePalma on-line!
See this thread for details.
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 Java Interview Guide this week in the Jobs Discussion 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: 42965
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!