• Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

How to hanlde .xls and .xlsx using poi api

 
rajesh yedula
Greenhorn
Posts: 11
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi All,

I have been using POI 3.2 jar work on reading data from excel sheets.But client wants to support both .xls and .xlsx formats.When i upload .xls it is working fine but when i try to upload .xlsx
i have been getting following error "Invalid header signature 449248204,Expected 23224248977".I heard somewhere to upgrade POI version but i could not able to do bcz i am integrating code in existed implementation.In existed implementation they are using POI 3.2 jar.Is there any ways to resolve this issue without upgrading to POI new versions?Please help me out to resolve this issue.


 
Tim Moores
Bartender
Posts: 2856
46
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
POI versions below 3.5 do not handle XLS. And even with a recent POI version you'll have to adapt your code to handle both formats.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic