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