DSXchange

Hi,

I couldn't read a from an excel sheet using java client source stage throwing the below error.

Fatal Error: Fatal: ExcelRead: Problem opening filejxl.read.biff.BiffException: Unable to recognize OLE stream

I had given the following properties in my job

filename-
Sheet-
TopLeft-
BottomRight-

and the transformer class name as ExcelRead and class path /java_etl/jxl.jar also provided.

Could you please share your thoughts to solve this issue?

Thanks
tom

Hi Tom,

This is not a solution to your problem but I want to know more about how to read excel files from DataSatge. Could you please provide more details on this.

Thanks,

Shashank

Can you read Excel worksheets using a different (non-DataStage) Java client?

What's in jxl.jar? Why you need it for?