AZURE data copy - ExcelUnsupportedFormat

Question

AZURE data copy - ExcelUnsupportedFormat

Admin KK - Marcin Struglinski 11

tries to copy data from dataset type excel from http service to dataset csv on AzureDataLakeStorage. I can check the data and schema excel dataset without any problems, but when copying I get the following message:

Failure type
User configuration issue
Details
Failure happened on 'Sink' side. ErrorCode=ExcelUnsupportedFormat,'Type=Microsoft.DataTransfer.Common.Shared.HybridDeliveryException,Message=Only '.xls' and '.xlsx' format is supported in reading excel file while error is ' at ICSharpCode.SharpZipLib.Zip.Compression.Streams.InflaterInputBuffer.ReadLeByte() at ICSharpCode.SharpZipLib.Zip.Compression.Streams.InflaterInputBuffer.ReadLeInt() at ICSharpCode.SharpZipLib.Zip.ZipInputStream.GetNextEntry() at NPOI.OpenXml4Net.Util.ZipInputStreamZipEntrySource..ctor(ZipInputStream inp) at NPOI.OpenXml4Net.OPC.ZipPackage..ctor(Stream filestream, PackageAccess access) at NPOI.OpenXml4Net.OPC.OPCPackage.Open(Stream in1) at NPOI.Util.PackageHelper.Open(Stream is1) at NPOI.XSSF.UserModel.XSSFWorkbook..ctor(Stream is1) at Microsoft.DataTransfer.ClientLibrary.ExcelUtility.GetExcelWorkbook(String fileExtension, TransferStream stream)'.,Source=Microsoft.DataTransfer.ClientLibrary,''Type=ICSharpCode.SharpZipLib.Zip.ZipException,Message=EOF in header,Source=ICSharpCode.SharpZipLib,'

Pavel Zemnukhov 20 Reputation points

2024-11-12T06:43:21.13+00:00

The issue still exists, it's definitely a bug.

Files I try to download are Excel and used to be working properly before until recently it started to throw errors from time to time. Nothing changed, the files are .xlsx and the preview works perfectly without any issues.

{ "errorCode": "2200", "message": "ErrorCode=ExcelUnsupportedFormat,'Type=Microsoft.DataTransfer.Common.Shared.HybridDeliveryException,Message=Only '.xls' and '.xlsx' format is supported in reading excel file while error is ' at ICSharpCode.SharpZipLib.Zip.Compression.Streams.InflaterInputBuffer.ReadLeByte()\r\n at ICSharpCode.SharpZipLib.Zip.Compression.Streams.InflaterInputBuffer.ReadLeInt()\r\n at ICSharpCode.SharpZipLib.Zip.ZipInputStream.GetNextEntry()\r\n at NPOI.OpenXml4Net.Util.ZipInputStreamZipEntrySource..ctor(ZipInputStream inp)\r\n at NPOI.OpenXml4Net.OPC.ZipPackage..ctor(Stream filestream, PackageAccess access)\r\n at NPOI.OpenXml4Net.OPC.OPCPackage.Open(Stream in1)\r\n at NPOI.Util.PackageHelper.Open(Stream is1)\r\n at NPOI.XSSF.UserModel.XSSFWorkbook..ctor(Stream is1)\r\n at Microsoft.DataTransfer.ClientLibrary.ExcelUtility.GetExcelWorkbook(String fileExtension, TransferStream stream)'.,Source=Microsoft.DataTransfer.ClientLibrary,''Type=ICSharpCode.SharpZipLib.Zip.ZipException,Message=EOF in header,Source=ICSharpCode.SharpZipLib,'", "failureType": "UserError", "target": "Copy activity name", "details": [] }
Pavel Zemnukhov 20 Reputation points

2024-12-01T23:01:46.4666667+00:00

There is a feedback ticket created for the root cause of this issue, please up vote.
https://feedback.azure.com/d365community/idea/68f243ae-31ae-ef11-95f6-000d3ae2b698

2 answers

Your answer

Pavel Zemnukhov 20 Reputation points

2024-11-12T06:43:21.13+00:00

The issue still exists, it's definitely a bug.

Files I try to download are Excel and used to be working properly before until recently it started to throw errors from time to time. Nothing changed, the files are .xlsx and the preview works perfectly without any issues.

{ "errorCode": "2200", "message": "ErrorCode=ExcelUnsupportedFormat,'Type=Microsoft.DataTransfer.Common.Shared.HybridDeliveryException,Message=Only '.xls' and '.xlsx' format is supported in reading excel file while error is ' at ICSharpCode.SharpZipLib.Zip.Compression.Streams.InflaterInputBuffer.ReadLeByte()\r\n at ICSharpCode.SharpZipLib.Zip.Compression.Streams.InflaterInputBuffer.ReadLeInt()\r\n at ICSharpCode.SharpZipLib.Zip.ZipInputStream.GetNextEntry()\r\n at NPOI.OpenXml4Net.Util.ZipInputStreamZipEntrySource..ctor(ZipInputStream inp)\r\n at NPOI.OpenXml4Net.OPC.ZipPackage..ctor(Stream filestream, PackageAccess access)\r\n at NPOI.OpenXml4Net.OPC.OPCPackage.Open(Stream in1)\r\n at NPOI.Util.PackageHelper.Open(Stream is1)\r\n at NPOI.XSSF.UserModel.XSSFWorkbook..ctor(Stream is1)\r\n at Microsoft.DataTransfer.ClientLibrary.ExcelUtility.GetExcelWorkbook(String fileExtension, TransferStream stream)'.,Source=Microsoft.DataTransfer.ClientLibrary,''Type=ICSharpCode.SharpZipLib.Zip.ZipException,Message=EOF in header,Source=ICSharpCode.SharpZipLib,'", "failureType": "UserError", "target": "Copy activity name", "details": [] }
Pavel Zemnukhov 20 Reputation points

2024-12-01T23:01:46.4666667+00:00

There is a feedback ticket created for the root cause of this issue, please up vote.
https://feedback.azure.com/d365community/idea/68f243ae-31ae-ef11-95f6-000d3ae2b698

Answer 1

ShaikMaheer-MSFT 38,546 Microsoft Employee Moderator

Hi @Admin KK - Marcin Struglinski ,

Welcome to Microsoft Q&A Platform. Thank you for posting your query here.

By error message it seems your excel sour data file format is not .xls or .xlsx. And currently, ADF will support these two types only. Kindly recheck your source file format once?

Could you please share your pipeline/ datasets json to go through configurations and following along so that we can repro scenario and help on resolution?

ShaikMaheer-MSFT 38,546 Reputation points Microsoft Employee Moderator

2021-08-10T05:14:30.417+00:00

Hi @Admin KK - Marcin Struglinski ,

Following up to check did you get chance to share requested details on above comment? Thank you.
ShaikMaheer-MSFT 38,546 Reputation points Microsoft Employee Moderator

2021-08-30T07:34:24.163+00:00

Hi @Admin KK - Marcin Struglinski ,

Just checking you get change to look above answer and share requested details?
Anonymous

2021-08-30T08:04:39.393+00:00

HI How get wildcard path dynamic in data flow ? ![127543-capture.png][1] [1]: /api/attachments/127543-capture.png?platform=QnA
ShaikMaheer-MSFT 38,546 Reputation points Microsoft Employee Moderator

2021-09-01T11:35:47.547+00:00

Hi anonymous user ,

Kindly check below document which explains how to write wild card paths.
https://learn.microsoft.com/en-us/azure/data-factory/connector-azure-blob-storage?tabs=data-factory#folder-and-file-filter-examples

Please feel free to open new thread. Thank you.
Arshad Ayub Kotwal 0 Reputation points

2023-05-05T05:59:30.3766667+00:00

Have we got a solution on this? same issue from end.

Answer 2

The issue still exists, it's definitely a bug.

I used to download files without any problems until it started to throw errors from time to time. Files are .xlsx and preview works perfectly.

{ "errorCode": "2200", "message": "ErrorCode=ExcelUnsupportedFormat,'Type=Microsoft.DataTransfer.Common.Shared.HybridDeliveryException,Message=Only '.xls' and '.xlsx' format is supported in reading excel file while error is ' at ICSharpCode.SharpZipLib.Zip.Compression.Streams.InflaterInputBuffer.ReadLeByte()\r\n at ICSharpCode.SharpZipLib.Zip.Compression.Streams.InflaterInputBuffer.ReadLeInt()\r\n at ICSharpCode.SharpZipLib.Zip.ZipInputStream.GetNextEntry()\r\n at NPOI.OpenXml4Net.Util.ZipInputStreamZipEntrySource..ctor(ZipInputStream inp)\r\n at NPOI.OpenXml4Net.OPC.ZipPackage..ctor(Stream filestream, PackageAccess access)\r\n at NPOI.OpenXml4Net.OPC.OPCPackage.Open(Stream in1)\r\n at NPOI.Util.PackageHelper.Open(Stream is1)\r\n at NPOI.XSSF.UserModel.XSSFWorkbook..ctor(Stream is1)\r\n at Microsoft.DataTransfer.ClientLibrary.ExcelUtility.GetExcelWorkbook(String fileExtension, TransferStream stream)'.,Source=Microsoft.DataTransfer.ClientLibrary,''Type=ICSharpCode.SharpZipLib.Zip.ZipException,Message=EOF in header,Source=ICSharpCode.SharpZipLib,'", "failureType": "UserError", "target": "Copy data", "details": [] }

Share via

AZURE data copy - ExcelUnsupportedFormat

2 answers

Your answer