Unable to read from an Excel file using java client stage

tom · Post by **tom** » Mon Mar 03, 2008 4:35 pm

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

ShashankDon · Post by **ShashankDon** » Tue Mar 04, 2008 4:14 pm

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

ray.wurlod · Post by **ray.wurlod** » Tue Mar 04, 2008 5:28 pm

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

lstsaur · Post by **lstsaur** » Tue Mar 04, 2008 5:53 pm

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