One Star

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
3 REPLIES
Moderator

Re: Can't open the specified file

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

Best regards
Sabrina
--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.
One Star

Re: Can't open the specified file

Yes, I have the admin role on my PC
Moderator

Re: Can't open the specified file

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
--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.