ErrorCode=EncryptedExcelIsNotSupported,'Type=Microsoft.DataTransfer.Common.Shared.HybridDeliveryException,Message=Encrypted excel file

B, Ravi (Cognizant) 26

I am getting the below error:

ErrorCode=EncryptedExcelIsNotSupported,'Type=Microsoft.DataTransfer.Common.Shared.HybridDeliveryException,Message=Encrypted excel file 'Table2.xlsx' is not supported, please remove its password.,Source=Microsoft.DataTransfer.ClientLibrary,''Type=ICSharpCode.SharpZipLib.Zip.ZipException,Message=Wrong Local header signature: 0x6769726F,Source=ICSharpCode.SharpZipLib,'

I removed protection and no encryption found in my excel but still showing same error in while loading data from adf to table.

Thanks in advance,
Ravi

Sumarigo-MSFT 47,286 Reputation points Microsoft Employee

2022-01-10T07:51:41.783+00:00

@B, Ravi (Cognizant) For better understanding the issue: Can you please elaborate bit more on your query?
Can you share the screen shot the error message? When exactly are you getting this error message ? Are you trying to copy data from ADF to Azure Files?

Based on the error message: Please refer to the suggestion mentioned in this thread and here

Additional information: https://learn.microsoft.com/en-us/azure/data-factory/connector-azure-blob-storage?tabs=data-factory#folder-and-file-filter-examples

Excel file format in Azure Data Factory and Azure Synapse Analytics

How to copy a password protected excel file in azure data factory?

----------

Please do not forget to Accept as Answer and “up-vote” wherever the information provided helps you, this can be beneficial to other community members.
B, Ravi (Cognizant) 26 Reputation points

2022-01-10T07:54:14.423+00:00

I am copying files from sftp to adls and then to adls to stagingtable using adf. when file copied to adls, while trying to load staging table, i am getting this error

Accepted answer

ShaikMaheer-MSFT 38,466 Reputation points Microsoft Employee

2022-01-10T14:34:22.03+00:00

Hi @B, Ravi (Cognizant) ,

It looks your file is still encrypted and protected. At this moment ADF will not support encrypted or protected excel files out of box. We might need to depend on additional functionality, such as using Azure function apps to extract data from it Or customer code to convert encrypted excel to normal one and then copy.

To make sure, your excel is encrypted or not could you please try to open it and see in adls and also in local?

Below link will be helpful to work with encrypted excel files.
* https://stackoverflow.com/questions/68775892/how-to-copy-a-password-protected-excel-file-in-azure-data-factory
* https://learn.microsoft.com/en-us/azure/data-factory/format-excel

Hope this will help. Please let us know if any further queries.

Please consider hitting Accept Answer. Accepted answers helps community as well.
Please sign in to rate this answer.
B, Ravi (Cognizant) 26 Reputation points

2022-01-11T00:24:32.717+00:00

I checked in my excel. It is neither protected nor encrypted. but still receiving this error

ShaikMaheer-MSFT 38,466 Reputation points Microsoft Employee

2022-01-19T13:39:06.217+00:00

Hi @B, Ravi (Cognizant) , Thanks for update. Its strange that error message still says same. Could you please try with any other excel file and see if its giving same error for them too or not?

ShaikMaheer-MSFT 38,466 Reputation points Microsoft Employee

2022-01-21T16:35:02.257+00:00

Hi @B, Ravi (Cognizant) - Did you get chance to try above and share updates.

Pavan Pai 1 Reputation point

2022-05-04T06:09:52.42+00:00

Hello @ShaikMaheer-MSFT ,
I am facing the same problem as well. I am trying to copy data from excel file present in google drive to an excel file present in azure blob storage container. The error i am receiving is as follows - ErrorCode=EncryptedExcelIsNotSupported,'Type=Microsoft.DataTransfer.Common.Shared.HybridDeliveryException,Message=Encrypted excel file. But, when i try to open the file in the container the error message is Excel cannot open the file because the file format or file extension is not valid. The excel file from the source is not encrypted or password protected. Please let me know if you have any suggestions here.

Thank you,
Sign in to comment

Use comments to ask for clarification, additional information, or improvements to the question.

1 additional answer

B, Ravi (Cognizant) 26 Reputation points

2022-01-21T16:38:54.053+00:00

Hi ShaikMaheer-MSFT,

I converted to those excels into csv and processed it. Tried with other excels also but not working. So converted into csv and done it
Please sign in to rate this answer.

1 person found this answer helpful.
ShaikMaheer-MSFT 38,466 Reputation points Microsoft Employee

2022-01-24T16:52:48.177+00:00

Hi @B, Ravi (Cognizant) , Thank you for sharing your work around. Please consider hitting Accept Answer for your answer. Accepted answers helps community as well.
Sign in to comment

Use comments to ask for clarification, additional information, or improvements to the question.

Share via

ErrorCode=EncryptedExcelIsNotSupported,'Type=Microsoft.DataTransfer.Common.Shared.HybridDeliveryException,Message=Encrypted excel file

1 additional answer

Your answer