Uanble to read excel file from SFTP server in Azure ADF

Question

Uanble to read excel file from SFTP server in Azure ADF

siya1234 1

Error details
Error code
21359
Details
Encrypted excel file 'SAMPLE.XLSX' is not supported, please remove its password.
Wrong Local header signature: 0x41D
Activity ID: 70462da3-07e6-4d98-8373-85bdbb0fe9bc

ShaikMaheer-MSFT 38,636 Reputation points Microsoft Employee Moderator

2022-10-06T08:57:19.407+00:00

Hello @siya1234 ,

Just checking in to see if the above answer helped. If this answers your query, do click and upvote for the same. And, if you have any further query do let us know.

2 answers

Your answer

ShaikMaheer-MSFT 38,636 Reputation points Microsoft Employee Moderator

2022-10-06T08:57:19.407+00:00

Hello @siya1234 ,

Just checking in to see if the above answer helped. If this answers your query, do click and upvote for the same. And, if you have any further query do let us know.

Answer 1

Pratik Somaiya 4,211 Volunteer Moderator

Hello @siya1234

As said by @Dillon Silzer , first check if the file is encrypted and has a password, if yes then remove it and then place it again on SFTP

Currently, ADF will not support decrypting a password protected file, but if that is your requirement, you will either have to use a different component like Azure Function

You can find more details in a similar type of question here

Rajeshk-8659 0 Reputation points

2024-11-18T21:24:01.1833333+00:00

Hi, I am also getting same error message, File is not encrypted and no password

Thanks

Answer 2

Dillon Silzer 60,816 Volunteer Moderator

Hi @siya1234

I'd probably follow the error Encrypted excel file 'SAMPLE.XLSX' is not supported, please remove its password.. Try placing a SAMPLE.XLSX on your SFTP Server that is not encrypted and try to reconnect ADF.

-----------------------------

If this is helpful please accept answer.

Share via

Uanble to read excel file from SFTP server in Azure ADF

2 answers

Your answer