• Index
  •  » Talend Open Studio for Data Integration » Usage, Operation
  •  » Question on jxl library regarding xlsx files (Excel 2007 and higher)

#1 2010-09-07 02:40:22

anand14
Member
Registered: 2010-08-18
Posts: 27

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,

Offline

  • Index
  •  » Talend Open Studio for Data Integration » Usage, Operation
  •  » Question on jxl library regarding xlsx files (Excel 2007 and higher)

Board footer

Powered by FluxBB