Win a copy of Learn Spring Security (video course) this week in the Spring forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

How to read excel2007 file or both .xls and .xlsx files using apache poi

 
harini veerapur
Greenhorn
Posts: 9
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Dear sir,
How to read a .xlsx files using poi ,i am able to read only .xls files using poi and if i read a .xlsx file it throws an exception so give me some sample code to read both .xls and .xlsx files using poi .
Thanks........
 
Ulf Dittmer
Rancher
Pie
Posts: 42967
73
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Note that POI versions before 3.5 do not support XSLX.

If you are, in fact, using a POI version that does support XLSX, post the code you're using. Knowing what exception is thrown would also be useful.
 
harini veerapur
Greenhorn
Posts: 9
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
My code as follows...




Thanks...
 
Ulf Dittmer
Rancher
Pie
Posts: 42967
73
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
The HSSF* classes are for working with XLS files, not XLSX. There are other classes (in some package called *.ss.*) that work with both formats; the POI documentation has the details on that.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic