Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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.
Hello su66,
Thanks for sharing your solution here.
Best regards
Sabrina
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.
@nischal,can you un tick Read excel2007 file format(xlsx) in Basic settings of tFileInputExcel?
Thanks All for your reply, my issue has resolved and there is a .XLS file issue not for the properties in the tFileInputExcel.
Hola
Yo tenia el mismo problema. Era un archivo oculto.
Al borrarlo se solucionó