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

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Unexpected end of ZLIB input stream + tFileExcelWorkbookOpen

Hi All,
I am using below components for operation on the *.xlsm file (excel file with macro enabled).
tFileExcelWorkbookOpen
tFIleExcelSheetInput / tFIleExcelSheetOutput
tFileExcelWorkbookSave.

Most of the time, it works fine, but some times I get the below exception. Please let me know the cause and solution for the same.
Exception in component tFileExcelWorkbookOpen_1
java.io.EOFException: Unexpected end of ZLIB input stream
at java.util.zip.InflaterInputStream.fill(InflaterInputStream.java:240)
at java.util.zip.InflaterInputStream.read(InflaterInputStream.java:158)
at java.util.zip.ZipInputStream.read(ZipInputStream.java:193)
at java.io.FilterInputStream.read(FilterInputStream.java:107)
at org.apache.poi.openxml4j.util.ZipInputStreamZipEntrySource$FakeZipEntry.<init>(ZipInputStreamZipEntrySource.java:127)
at org.apache.poi.openxml4j.util.ZipInputStreamZipEntrySource.<init>(ZipInputStreamZipEntrySource.java:55)
at org.apache.poi.openxml4j.opc.ZipPackage.<init>(ZipPackage.java:83)
at org.apache.poi.openxml4j.opc.OPCPackage.open(OPCPacka

Thanks In Advance
Chaya
Labels (4)
2 Replies
Anonymous
Not applicable
Author

Hi,
tFileExcelWorkbookOpen, tFileExcelSheetInput / tFileExcelSheetOutput, tFileExcelWorkbookSave are custom components, developed by our community user ( jlolling) and shared on Talend Exchange. You had better contact the author of the components.
Best regards.
Sabrina
Anonymous
Not applicable
Author

Thanks Sabrina,
Will check with them.