[resolved] FTPGet - Problem with Excel File

[Anonymous]

Hi,
i have a Excel File on my FTP Server, if i download the file with FileZilla all is ok , i can open the file wthout problems.
If i download the file in Talen with tFTPGet the the file is download without error, but i cant open it with Excel or read with Talend.
Excel said File Format is corrupt.
Talend Error Message is:
xception in component tFileInputExcel_1
org.apache.poi.openxml4j.exceptions.InvalidOperationException: Can't open the specified file: 'D:\EDI\Bestellungen\Input\test_pedido_2018_08_v1.xls'
at org.apache.poi.openxml4j.opc.ZipPackage.<init>(ZipPackage.java:108)
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:67)
at org.apache.poi.xssf.usermodel.XSSFWorkbook.<init>(XSSFWorkbook.java:263)
I have testet with Tranfermode ascii and binary as well - same error.
Thanks for help
Dani

[Anonymous]

HI,
Please provide sample file, so we can better analyze the problem

[Anonymous]

Hi Dani,
Have you already figured out the issue? We see that this topic is marked as resolved.
Feel free to let us know if you still have any error in your job.

Best regards
Sabrina

[Anonymous]

Hi, 
I'm having the same issue. Can anyone please provide the solution?
tFTPGet component is transferring the file to the local location. But when I open the file, I get an error " File cannot be accessed. the file may be corrupted, located on a server that is not responding , or read-only." 
I can access or transfer the same file through CORE FTP client tool with out any issues.
Regards 
Sunil

[jasonatunr]

I am having this same problem with sftp. Anyone solve this?

[Anonymous]

Hello,

Do you have the admin role to read your file? Is it locked? Are you able to open it out side of talend studio?

Best regards

Sabrina