Reading a xls file using POI or jxl which actually neither in xls file nor a .xlsx throws Unable to recognize OLE stream

173 Views Asked by At

I want to open a .xls file which not supported by Apache POI since the file is neither a .xls file nor a .xlsx one. If you open it in a text editor, you'll see that instead it's HTML! Please see https://bz.apache.org/bugzilla/show_bug.cgi?id=51031

As per the java.lang.IllegalArgumentException: Your InputStream was neither an OLE2 stream, nor an OOXML stream

I also tried with jxl and it throws jxl.read.biff.BiffException: Unable to recognize OLE stream.

only way to bypass this is save it again ,since I 'am using an automation script can anyone suggest a walkaround .

0

There are 0 best solutions below