Question on jxl library regarding xlsx files (Excel 2007 and higher)

One Star

Question on jxl library regarding xlsx files (Excel 2007 and higher)

Hi all,
I am using the following:
Talend Version: 4.0.2.r43696
Platform: Windows 7
I am using the jxl library to read Excel files in Talend. My job works great with .xls files (Excel 97, Excel 2003 etc). However, I am experiencing problems with .xlsx files (Excel 2007 )
Even if I save the .xlsx file as a .xls file, I get the following error on Talend (when I try to read it via the jxl library)
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)

Someone on the forums asked me to check the "Excel 2007" option on the tFileInputExcel component. If I check that option, I get the following error:
Exception in component tFileInputExcel_1
org.apache.poi.openxml4j.exceptions.InvalidOperationException: Can't open the specified file: 'null'
at org.apache.poi.openxml4j.opc.ZipPackage.<init>(ZipPackage.java:102)
at org.apache.poi.openxml4j.opc.OPCPackage.open(OPCPackage.java:199)
at org.apache.poi.openxml4j.opc.OPCPackage.open(OPCPackage.java:178)
at org.apache.poi.POIXMLDocument.openPackage(POIXMLDocument.java:62)
at org.apache.poi.xssf.usermodel.XSSFWorkbook.<init>(XSSFWorkbook.java:167
Has anyone encountered this while using Talend ? I am pretty sure I am not the first guy to run into this problem.
I would appreciate any input from the Talend/Excel gurus.
Thanks,