Azure Data Factory does not natively support .xlsb files. As a workaround, you can create an Azure Function or Logic App that can convert .xlsb files to .xlsx or .csv format https://techmindfactory.com/Extract-Excel-file-content-with-Azure-Logic-Apps-and-Azure-Functions/ Set up your Logic App or Azure Function to trigger when a new file is uploaded to your storage account. You can use Azure Event Grid for an event-driven architecture to automate. After extracting data from the Excel file, store it in Azure Cosmos DB or another database of your choice. Once the conversion process is complete and the data is stored, you can use the Copy Activity in Azure Data Factory to move the data from the converted files to your SQL Server database or another destination as required.
How to convert .xlsb extension file into xlsx file using LogicAPP
Hi, I have File with extension of .xlsb which I should then load into DataLake. The email is sent by the business with the attachment. Now I have done the following steps, Designed the Logic APP to extract the Email Attachment and upload in Blob Container. Then ADF Pipeline will load the file to datalake using copy activity. Now could you suggest the best solution to convert the binary extension into xlsx and post in blob so that I dont have to change the generic pipeline used. Or should I again use copy Activity in the Pipeline to convert xlsb to xlsx?. Please suggest and confirm.
2 answers
Sort by: Most helpful
-
-
AnnuKumari-MSFT 34,011 Reputation points Microsoft Employee
2024-01-15T11:12:16.8933333+00:00 Hi Jenovia Y ,
Welcome to the Microsoft Q&A platform and thanks for posting your query here.
Azure Data Factory does not natively support .xlsb or .xlsm file formats.
Supported file formats: https://learn.microsoft.com/en-us/azure/data-factory/format-excel
- Below is the feedback feature request in the ADF feedback channel for adding Excel Binary (xlsb) files in ADF connector list , which would be open for the user community to upvote & comment on. This allows our product teams to effectively prioritize your request against our existing feature backlog and gives insight into the potential impact of implementing the suggested feature.
https://feedback.azure.com/d365community/idea/ab1aad12-7226-ec11-b6e6-000d3a4f032c
- As a workaround you can create an Azure Function or Logic App that converts .xlsb or .xlsm files to .xlsx or .csv format. You can use a library like openpyxl for Python or EPPlus for .NET to handle the conversion.
Hope it helps. Kindly accept the answer by clicking on
Accept answer
button. Thankyou