"Unable to recognize OLE stream" excepion while connecting to Excel

Solution 1:

JXL supports Excel worksheets created in Excecl 95/97 and 2000 -

Read the below in the official JXL site - http://www.andykhan.com/jexcelapi/

Features

Reads data from Excel 95, 97, 2000 workbooks Reads and writes formulas (Excel 97 and later only) Generates spreadsheets in Excel 2000 format

Your excel sheet seems to be created after Excel 2000. That seems to be the problem.

If you want to read Excel files created after Excel 2000 then you should use Apache POI. It is also an easy to use API and supports MS Excel 97 to MS Excel 2008.