Tag Archives: Unable to recognize OLE stream

[Solved] Java read excel file unable to recognize ole stream error

Error:

jxl.read.biff.BiffException: Unable to recognize OLE stream
at jxl.read.biff.CompoundFile.<init>(CompoundFile.java:116)
at jxl.read.biff.File.<init>(File.java:127)
at jxl.Workbook.getWorkbook(Workbook.java:268)
at jxl.Workbook.getWorkbook(Workbook.java:253)
at test1.main(test1.java:25)

Solution: No expenditure to read excel 2007 files (*.xlsx). Only excel 2003 (*.xls) is supported.

jxl.read.biff.BiffException: Unable to recognize OLE stream

This exception occurs because the file is Excel2007, and jxl parsing 07 will report the above exception, that is, jxl can handle Excel2003

Solution:

Open the file, save the file as in the upper right corner, select the type 2003 file , (what will happen if you haven’t tried the 2003 template)

Change the imported file name to the current one, try it