Error - Unable to recognize OLE stream

Situation:

When executing a custom plugin, I'm receiving the following error:

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

Cause:

In the plugin jxl api's(Java Excel API) is used to read the Excel file. The JXL Api's does not support the Excel 2007+(.xlsx) it only supports the old BIFF (binary) ".xls" format and that is the reason it is throwing the error

 

Solution:

  1. Parse only the .xls file using this custom plugin.

  2. Or try using the Apache POI Project to support both the formats. Please refer the below link for more information:

    http://poi.apache.org/

Have more questions? Submit a request

0 Comments

Article is closed for comments.