JXL Exception when uploading MS Office 2007 -Unable to recognize OLE stream

[Former Member]

Dear team,

I am trying to upload an excel file using jxl jar , using the below code,

InputStream bais =wdContext.currentContextElement().getQuestionsetUpload().read(true);
Workbook workbook = Workbook.getWorkbook(bais);
Sheet sheet = workbook.getSheet(0);

But i am getting an execption jxl.read.biff.BiffException: Unable to recognize OLE stream when i upload an excel file of Microsoft Office 2007 version.

Kindly help me in solving the exception

Regards,

Shamila

[Former Member]

Hi Shamila,

Pls refer below link:-

The Exception rasied may be due to incompatable version.

Try to save your Excel file in the format 97-2003 and Try.

http://www.archivesat.com/JExcelApi/thread362381.htm

Deepak!!!

Edited by: Deepak Arora on Apr 13, 2010 8:11 AM

Edited by: Deepak Arora on Apr 13, 2010 8:24 AM