Win a copy of Re-engineering Legacy Software this week in the Refactoring forum
or Docker in Action in the Cloud/Virtualization forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Read an Excel file

 
Arun kartik Rajendran
Greenhorn
Posts: 10
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
How to read an .xls file using java on column basis
 
Jeff Verdegan
Bartender
Posts: 6109
6
Android IntelliJ IDE Java
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 158
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi Arun kartik Rajendran,

Following link will help you.

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

Regards,
James
 
Ulf Dittmer
Rancher
Pie
Posts: 42967
73
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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.
 
Arun kartik Rajendran
Greenhorn
Posts: 10
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Thanks... I got it
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic