topic [resolved] Unable to read an excel file with tFileInputExcel in Talend Studio

[resolved] Unable to read an excel file with tFileInputExcel

_AnonymousUser — Sat, 16 Nov 2024 11:24:11 GMT

I have the same problem but the format of my excel file is : csv
and i'm getting this error: Exception in component tFileInputExcel_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:268)
at expenses.binghandling_0_1.BINGHANDLING.tFileList_1Process(BINGHANDLING.java:1012)
how can i read csv file by tfileinputexcel without getting the exception?
i used tfilrlist and marked the option of "use global expressions as filmask"
and put in the filemask:"*.csv"

Re: [resolved] Unable to read an excel file with tFileInputExcel

Anonymous — Wed, 03 Dec 2014 02:09:26 GMT

Hi,
Have you checked out option "Read excel 2007 file format(xlsx)" when reading your excel file?
Best regards
Sabrina

Re: [resolved] Unable to read an excel file with tFileInputExcel

Anonymous — Wed, 03 Dec 2014 06:41:51 GMT

Hi Shani,
Format of excel file is not csv, but the association of csv file is with excel in windows. (What is the file extension in file properties?)
use tFileInputDelimited to create metadata for your input csv file and try again,
Thanks
Vaibhav