Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Write Table now available in Qlik Cloud Analytics: Read Blog
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

ZIP_Read: error reading zip file

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.
Labels (4)
17 Replies
Anonymous
Not applicable
Author

Hi,
We can create file excel metadata for your input excel file. It works well on my side. Could you please take a look at my screenshots?
Best regards
Sabrina
0683p000009MC5y.png 0683p000009MC63.png 0683p000009MC0L.png
Anonymous
Not applicable
Author

Hi Sankalp,
I am using "tFileInputExcel" to read the file.
THanks
Anonymous
Not applicable
Author

Hi spatel,
Can you successfully read the excel file by a simple job: tfileinputexcel-->tlogrow?
Best regards
Sabrina
Anonymous
Not applicable
Author

0683p000009MBlp.pngYes, without any issues.
Thanks
Anonymous
Not applicable
Author

Hi,
Exception in component tFileInputExcel_4
org.apache.poi.POIXMLException: java.util.zip.ZipException: ZIP_Read: error reading zip file

What does your whole job design look like? Does this issue only repro on a specific job?
Best regards
Sabrina
Anonymous
Not applicable
Author

0683p000009MBmn.pngI have highlighted the component that errors out.
Anonymous
Not applicable
Author

Hi,
What's talend product solution you are using? open source or subscription solution? Your have a big job, which is a little hard for us to address your issue from screenshot.
Best regards
Sabrina
Anonymous
Not applicable
Author

Belated feedback:  I've found this can be equivalent to a "file not found" error.  Mine were caused by mis-named input files.