Azure Data Factory - Write to Excel

Rakesh Singh 16 Reputation points
2022-01-27T19:41:43.153+00:00

I have been looking for a way to export data from Azure Blob store container having csv files into Excel after doing some transformations/filtering etc.,

There are about 40 Excel reports with pre defined colour/format etc to be generated every day.

I was under the impression ADF can be used but there is sink to excel option in ADF.

Its quite a simple ask within SSIS but ADF doesn't seem to have such?

Has anyone tried doing such an export with Custom Activity?
Perhaps creating Excel application instance in c# and writing data to it and saving to either blob store or one drive/sharepoint?

Azure Blob Storage
Azure Blob Storage
An Azure service that stores unstructured data in the cloud as blobs.
2,409 questions
Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
9,463 questions
{count} votes

1 answer

Sort by: Most helpful
  1. svijay-MSFT 5,201 Reputation points Microsoft Employee
    2022-01-28T16:38:17.407+00:00

    Hello @Rakesh Singh ,

    Thanks for the ask and using Microsoft Q&A platform .

    If my understanding is correct, you would like to pull in CSV files that are stored in the Blob and write it as Excel File.

    Like you mentioned/aware - currently - the ADF doesn't support Excel as a sink. Having said that, I would suggest you to provide feedback on the same:

    Feedback Portal - Azure Data factory

    All of the feedback you share in these forums will be monitored and reviewed by the Microsoft engineering teams responsible for building Azure.

    Now the work around I can think is making use of Logic App / Power Automate.

    You could pull in the CSV file and do data manipulation (Filtering/Transformation store it in an Excel file.

    Reference : https://social.msdn.microsoft.com/Forums/en-US/a08b6d3a-f492-4f26-9309-e172553e9fdf/convert-csv-to-excel-in-azure-blob-storage?forum=azurelogicapps

    169398-image.png

    You get the data for each row - you will perform any applicable transformation - update each row to excel

    Please do let me know how it goes.

    -------------------------------------------------------------------------------------------------------------------------

    • Please don't forget to click on 130616-image.png or upvote 130671-image.png button whenever the information provided helps you. Original posters help the community find answers faster by identifying the correct answer. Here is how
    • Want a reminder to come back and check responses? Here is how to subscribe to a notification
    • If you are interested in joining the VM program and help shape the future of Q&A: Here is how you can be part of Q&A Volunteer Moderators