topic Re: Unable to recognize OLE stream for reading .xls file. in Talend Studio

Unable to recognize OLE stream for reading .xls file.

Anonymous — Sun, 03 Mar 2013 10:58:25 GMT

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.

Re: Unable to recognize OLE stream for reading .xls file.

Anonymous — Sun, 03 Mar 2013 14:30:56 GMT

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.

Re: Unable to recognize OLE stream for reading .xls file.

Anonymous — Mon, 04 Mar 2013 05:39:22 GMT

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.

Re: Unable to recognize OLE stream for reading .xls file.

Anonymous — Mon, 04 Mar 2013 08:25:53 GMT

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

Re: Unable to recognize OLE stream for reading .xls file.

Anonymous — Mon, 04 Mar 2013 08:30:23 GMT

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.

Re: Unable to recognize OLE stream for reading .xls file.

_AnonymousUser — Mon, 08 Apr 2013 10:41:56 GMT

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

Re: Unable to recognize OLE stream for reading .xls file.

Anonymous — Tue, 09 Apr 2013 05:15:25 GMT

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

Re: Unable to recognize OLE stream for reading .xls file.

_AnonymousUser — Tue, 09 Apr 2013 09:22:17 GMT

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

Re: Unable to recognize OLE stream for reading .xls file.

Anonymous — Tue, 09 Apr 2013 11:32:57 GMT

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

Re: Unable to recognize OLE stream for reading .xls file.

Anonymous — Tue, 09 Apr 2013 20:17:23 GMT

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!

Re: Unable to recognize OLE stream for reading .xls file.

Anonymous — Wed, 10 Apr 2013 08:44:39 GMT

Hi,
It is welcome that open a JIRA issue in the Talend DI project of the JIRA bugtracker for the new required feature.
Best regards
Sabrina

Re: Unable to recognize OLE stream for reading .xls file.

_AnonymousUser — Wed, 02 Mar 2016 09:43:59 GMT

@umeshrakhe:
Even i got the same issue today. My friend told, that its not an excle file. its just named as .xls or .xlsx...
it doesn't mean its excel file. Still u will be able to open the source file with microsoft excel app.
But talend cannot open it with tfileinputexcel component.
Try opening the source file with notepad... it may be tab delimited. so u can try to open it with tinputfiledelimited component.
Alternately you can also convert the input file as excel by opening and saving it as "excel work book" instead of "unicode text" format.
THANKS,
abhicool666@gmail.com

Re: Unable to recognize OLE stream for reading .xls file.

_AnonymousUser — Tue, 01 Nov 2016 06:18:28 GMT

Hi
I am facing this issue as well (Unable to recognize OLE stream).
i am using csv file as input and i am using the fileinputexcel whether it will work or not??

Re: Unable to recognize OLE stream for reading .xls file.

su66 — Fri, 27 Apr 2018 21:45:33 GMT

Hi, I faced same issue today. I tried to open my .xls file in notepad and it opened as a text file with tab delimited columns. I used tfileinputdelimited instead of tfileinputexcel and it worked.

Re: Unable to recognize OLE stream for reading .xls file.

Anonymous — Sat, 28 Apr 2018 08:23:26 GMT

Hello su66,

Thanks for sharing your solution here.

Best regards

Sabrina

Re: Unable to recognize OLE stream for reading .xls file.

nischal — Wed, 16 May 2018 07:29:02 GMT

Hello Talend team,

We are also getting the same issue while reading the data from .xls file. Following is the error message.

Exception in component tFileInputExcel_1 (tXLS2STGEMPTBL)
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:268)
at sandbox.txls2stgemptbl_0_1.tXLS2STGEMPTBL.tFileInputExcel_1Process(tXLS2STGEMPTBL.java:1472)
at sandbox.txls2stgemptbl_0_1.tXLS2STGEMPTBL.runJobInTOS(tXLS2STGEMPTBL.java:2388)
at sandbox.txls2stgemptbl_0_1.tXLS2STGEMPTBL.main(tXLS2STGEMPTBL.java:2214)

we are attaching the screen shot for the job and error message.

Kindly do needful for the same.

XLS_Reading_Error_TOS.png

Re: Unable to recognize OLE stream for reading .xls file.

manodwhb — Wed, 16 May 2018 08:08:34 GMT

@nischal,can you un tick Read excel2007 file format(xlsx) in Basic settings of tFileInputExcel?

Re: Unable to recognize OLE stream for reading .xls file.

nischal — Thu, 17 May 2018 11:16:42 GMT

Thanks All for your reply, my issue has resolved and there is a .XLS file issue not for the properties in the tFileInputExcel.

Re: Unable to recognize OLE stream for reading .xls file.

MidLyC — Thu, 31 Mar 2022 11:48:55 GMT

Hola

Yo tenia el mismo problema. Era un archivo oculto.

Al borrarlo se solucionó