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]

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

[_AnonymousUser]

@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

[_AnonymousUser]

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??

[su66]

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.

[Anonymous]

Hello su66,

Thanks for sharing your solution here.

Best regards

Sabrina

[nischal]

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

[manodwhb]

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

[nischal · Accepted solution]

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

[MidLyC]

Hola

Yo tenia el mismo problema. Era un archivo oculto.

Al borrarlo se solucionó