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

[former_member215511]

Hi,

i created a web dynpro java project to extract the data from excel file to table.In that got the fallowing eroor.

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

In this already i added the jxl.jar file to exteranal libraries of myproject and copy the same one into my lib folder also but i got the above Problem.

Please help me

Regards

Viswa

[former_member182598]

If you are using Excel 2007 Refer to

http://jira.pentaho.com/browse/PDI-2793

By the way why not use APACHE POI which has got better support?

Thanks

Prashant

[former_member215511]

HI,

Thanks for replay.I did n't understand your answer.please help me what i a=can i do to slove my error.

Regards

Viswa

[Former Member]

HI,

Make sure that u have created a library porject & refer that project in your WDJ DC. Jus refering the jxl.jar in your build path wont work.

Refer:

http://wiki.sdn.sap.com/wiki/display/WDJava/UploadingexcelfileusingWebDynproforJava

Thanks,

Arun

[former_member215511]

HI

Already i fallowed same document what you send to me,but i got the same error.

Regards

Viswa