One Star

[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"
2 REPLIES
Moderator

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

Hi,
Have you checked out option "Read excel 2007 file format(xlsx)" when reading your excel file?
Best regards
Sabrina
--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.
Four Stars

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