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

Question

question

BRaviCognizant-2051 asked Jan 9, '22 PavanPai-8058 edited May 4, '22

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

Hi

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

azure-files

· 2

5 |1600 characters needed characters left characters exceeded

Attachments: Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

SumanthMarigowda-MSFT · Jan 10 at 07:51 AM

@BRaviCognizant-2051 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://docs.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.

0 ·

image.png (4.9 KiB)

BRaviCognizant-2051 · Jan 10 at 07:54 AM

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

0 ·

Answer 1 · 2022-01-10T14:34:22.03Z

ShaikMaheer-MSFT answered Jan 10, '22 PavanPai-8058 edited May 4, '22

Hi @BRaviCognizant-2051 ,

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://docs.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.

· 4

5 |1600 characters needed characters left characters exceeded

Attachments: Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

BRaviCognizant-2051 · Jan 11 at 12:24 AM

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

0 ·

ShaikMaheer-MSFT BRaviCognizant-2051 · Jan 19 at 01:39 PM

Hi @BRaviCognizant-2051 , 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?

0 ·

ShaikMaheer-MSFT ShaikMaheer-MSFT · Jan 21 at 04:35 PM

Hi @BRaviCognizant-2051 - Did you get chance to try above and share updates.

0 ·

PavanPai-8058 · May 04 at 06:09 AM

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,

0 ·

Answer 2 · 2022-01-21T16:38:54.053Z

BRaviCognizant-2051 answered Jan 21, '22 ShaikMaheer-MSFT commented Jan 24, '22

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

· 1

5 |1600 characters needed characters left characters exceeded

Attachments: Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

ShaikMaheer-MSFT · Jan 24 at 04:52 PM

Hi @BRaviCognizant-2051 , Thank you for sharing your work around. Please consider hitting Accept Answer for your answer. Accepted answers helps community as well.

0 ·

question