Unable to recognize OLE stream for reading .xls file.

[Anonymous]

I am getting this error while loading .xls file from Talend. i am able to open after convert the file using Excel.
Please any solution.

 connecting to socket on port 3778
 connected
Exception in component tJava_1
jxl.read.biff.BiffException: Unable to recognize OLE stream
	at jxl.read.biff.CompoundFile.<init>(CompoundFile.java:116)
	at jxl.read.biff.File.<init>(File.java:127)
	at jxl.Workbook.getWorkbook(Workbook.java:221)
	at jxl.Workbook.getWorkbook(Workbook.java:198)
 disconnected
Job Tester ended at 16:21 03/03/2013. 

[Anonymous]

Did you created your own code in a tJava component using the jxl library? In this case at first try to read the file with the original tFileInputExcel component.
If you want writing your own code reading Excel, I would strongly recommend to switch to Apache POI. This library is much more reliable and has more features.

[Anonymous]

I did try with tFileInputExcel component, but fail to read. After open it using Notepad it seems like it is HTML file because it has style sheet values with HTML code i think this file is not normal Excel file. so what i am doing now, i am trying to parse HTML <table>.
Do you know any other way to read it or parse it.

[Anonymous]

Hi umeshrakhe,

Unable to recognize OLE stream

I have met this issue before, but I'm not sure it is the same occasion with yours. Usually, I will check out the option "Read excel 2007 file format(xlsx)".
Best regards
Sabrina

[Anonymous]

Hi xdshi
I tried this option also but not working for me, I will post you more details about file, so we can have better idea.

[_AnonymousUser]

I have the same problem an XLS file with html formatting.
unchecking xlsx box does not work for me either

[Anonymous]

Hi,

I have the same problem an XLS file with html formatting.
unchecking xlsx box does not work for me either

The XLS file cannot parsed in still, when you have checked out the option "Read excel 2007 file format(xlsx)". I'm afraid that our parsing don't support your complex formats.
We also use Apache tool jar to parse.
Best regards
Sabrina

[_AnonymousUser]

Do you have any suggestion as an alternative component?
If I rename that .xls file to .html it is perfect html data table viewable in browser.
best regards
Martin

[Anonymous]

Hi,
Actually, in talend there is not a input component which can read HTML file. And I have made a search on talend exchange portal for the custom component. Unfortunately, there is not a proper one. Maybe some one will give a wonderful idea, sorry for the inconvenience.
Best regards
Sabrina

[Anonymous]

Probably there is a developer who will create this for us.
As a requirement, I would say, it should be possible to define which table (per id or name or simple the first one) the component should parse and read.
In case of XHTML the simple tFileInputXML component should do this job!