Skip to Main Content

Java Development Tools

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How to read excel 2007 and 2003 documents using APACHE POI framework?

888012Sep 13 2011 — edited Sep 13 2011
Hi Frnds,

Please suggest me he code to read excel 2007 and excel 2003 documents using POI in java. I tried but I got the below exception msgs.

The supplied data appears to be in the Office 2007+ XML. You are calling the part of POI that deals with OLE2 Office Documents. You need to call a different part of POI to process this data (eg XSSF instead of HSSF).

Please send me the code if possible to read the data from excel using POI

Thanks,
Teja
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Oct 11 2011
Added on Sep 13 2011
5 comments
955 views