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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
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.