[resolved] Unable to read an excel file with tFileInputExcel
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"
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