How to convert .xlsb extension file into xlsx file using LogicAPP

Jenovia Y 0 Reputation points
2024-01-12T14:41:35.1366667+00:00

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.

Azure Logic Apps
Azure Logic Apps
An Azure service that automates the access and use of data across clouds without writing code.
3,348 questions
Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
11,245 questions
{count} votes

2 answers

Sort by: Most helpful
  1. Sedat SALMAN 14,150 Reputation points MVP
    2024-01-13T13:17:03.1266667+00:00

    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​​.

    0 comments No comments

  2. 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

    0 comments No comments

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.