ZIP_Read: error reading zip file

[Anonymous]

I am getting below error message and dont know why. This file is not a zip file, it is .xlsx file.
Exception in component tFileInputExcel_4
org.apache.poi.POIXMLException: java.util.zip.ZipException: ZIP_Read: error reading zip file
    at org.apache.poi.xssf.usermodel.XSSFSheet.onDocumentRead(XSSFSheet.java:182)
    at org.apache.poi.xssf.usermodel.XSSFWorkbook.onDocumentRead(XSSFWorkbook.java:300)
    at org.apache.poi.POIXMLDocument.load(POIXMLDocument.java:159)
    at org.apache.poi.xssf.usermodel.XSSFWorkbook.<init>(XSSFWorkbook.java:200)
    at org.apache.poi.xssf.usermodel.XSSFWorkbook.<init>(XSSFWorkbook.java:263)
Thank you.

[Anonymous]

Hi,
Could you please indicate what's the build version you are using? Would you mind sending your input file to us for testing?
Best regards
Sabrina

[Anonymous]

Talend Studio 5.6.1
Its an excel file, its not letting paste that file here.
Please help.

[Anonymous]

Talend Studio 5.6.1
Its an excel file, its not letting paste that file here.
Please help.

[JR1]

Actually, all xlsx files are zip files (try opening one with e.g. 7zip). The error message from Apache POI indicates that it cannot open the file. Apache POI is a Java library for handling MS documents which is used in all Talend Excel components. Can you open the file in question with MS Excel?

[JR1]

One more thing: is it really an xlsx file or an xls file? If it is an xlsx, you will have to check "Read excel2007 file format(xlsx)" in the tFileInputExcel component. If not, uncheck it.

[Anonymous]

Hello  spatel,
You can send your excel file to us by email directly. Is there any update for your issue?
Best regards
Sabrina

[Anonymous]

File is xlsx.
I can open this file in excel without any issues.
"Read excel2007" is checked.
what email address should I used to send file?
Thanks

[Anonymous]

Also which component are you using to read the file?

[Anonymous]

Hi,
We have sent an email to you('sangita.patel@optum.com'). Could you please check it?
Best regards
Sabrina