This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(256, 84%, 34%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMM%3C/text%3E%3C/svg%3E)
I get below error when I try to use copy activity to copy data from .xlsx in azure blob storage to SQL table. Any quick help will be much appreciated.
ErrorCode=ExcelUnsupportedFormat,'Type=Microsoft.DataTransfer.Common.Shared.HybridDeliveryException,Message=Only '.xls' and '.xlsx' format is supported in reading excel file while error is ' at NPOI.POIFS.Storage.HeaderBlock..ctor(Stream stream)
at NPOI.POIFS.FileSystem.POIFSFileSystem..ctor(Stream stream)
at Microsoft.DataTransfer.ClientLibrary.ExcelUtility.GetExcelWorkbook(String fileExtension, TransferStream stream)'.,Source=Microsoft.DataTransfer.ClientLibrary,''Type=NPOI.POIFS.FileSystem.NotOLE2FileException,Message=Invalid header signature; read 0x78474B3452384D30, expected 0xE11AB1A1E011CFD0 - Your file appears not to be a valid OLE2 document,Source=NPOI,'
Hello @Manasa M ,
Thanks for the question and using MS Q&A platform.
As per the error message it seems your excel source 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?
Hello @Manasa M ,
We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet. In case if you have any resolution please do share that same with the community as it can be helpful to others. Otherwise, will respond with more details and we will try to help.
Hello! I was able to resolve the issue. The problem was with the filetype. By changing the ContentType in my LogicApp which got triggered on an email resolved the filetype issue and gave a valid xls. Thank you for the follow up.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(236.8, 87%, 32%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ENG%3C/text%3E%3C/svg%3E)
Can you tell me exactly how you resolved the issue? I have exactly the same issue.
@Manasa M - I'm glad that you were able to resolve your issue and thank you for posting your solution so that others experiencing the same thing can easily reference this! Since the Microsoft Q&A community has a policy that "The question author cannot accept their own answer. They can only accept answers by others ", I'll repost your solution in case you'd like to accept the answer .
Ask: Error trying to copy data from .xlsx from azure blob storage to Azure SQL table
Solution: I was able to resolve the issue. The problem was with the filetype. By changing the ContentType in my LogicApp which got triggered on an email resolved the filetype issue and gave a valid xls.
If I missed anything please let me know and I'd be happy to add it to my answer, or feel free to comment below with any additional information.
If you have any other questions, please let me know. Thank you again for your time and patience throughout this issue.
Please don’t forget to Accept Answer and Yes for "was this answer helpful" wherever the information provided helps you, this can be beneficial to other community members.