Skip to Content
avatar image
Former Member

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

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

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

1 Answer

  • Apr 13, 2010 at 06:11 AM

    Hi Shamila,

    Pls refer below link:-

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

    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

    Add comment
    10|10000 characters needed characters exceeded