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

Announcements
Qlik and ServiceNow Partner to Bring Trusted Enterprise Context into AI-Powered Workflows. Learn More!
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Can't open the specified file

I download an excel file with the tFileFetch component and I try to open it
I get the following message:
Exception in component tFileInputExcel_1
org.apache.poi.openxml4j.exceptions.InvalidOperationException: Can't open the specified file: 'C:/Bureautique/200/DEVISES/arfolyam.xlsx'
    at org.apache.poi.openxml4j.opc.ZipPackage.<init>(ZipPackage.java:112)
    at org.apache.poi.openxml4j.opc.OPCPackage.open(OPCPackage.java:224)
    at org.apache.poi.openxml4j.opc.OPCPackage.open(OPCPackage.java:186)
    at org.apache.poi.POIXMLDocument.openPackage(POIXMLDocument.java:74)
    at org.apache.poi.xssf.usermodel.XSSFWorkbook.<init>(XSSFWorkbook.java:296)
    at pmi.test_0_1.test.tFileInputExcel_1Process(test.java:2063)
    at pmi.test_0_1.test.tFileFetch_1Process(test.java:467)
    at pmi.test_0_1.test.runJobInTOS(test.java:4130)
    at pmi.test_0_1.test.main(test.java:3987)
Caused by: java.util.zip.ZipException: error in opening zip file
    at java.util.zip.ZipFile.open(Native Method)
    at java.util.zip.ZipFile.<init>(Unknown Source)
    at java.util.zip.ZipFile.<init>(Unknown Source)
    at java.util.zip.ZipFile.<init>(Unknown Source)
    at org.apache.poi.openxml4j.opc.internal.ZipHelper.openZipFile(ZipHelper.java:174)
any ideas???
Thanks
Didier
0683p000009MAty.png 0683p000009MArx.png
Labels (4)
3 Replies
Anonymous
Not applicable
Author

Hi dihonore,
Do you have admin role to read this excel file which is located under C:/?

Best regards
Sabrina
Anonymous
Not applicable
Author

Yes, I have the admin role on my PC
Anonymous
Not applicable
Author

Hi,
Could you please check if your excel file is locked? Can you open your .xlsx file outside from Talend with Excel?

Best regards
Sabrina