Azure Data Factory - Write to Excel

Question

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?

Answer 1

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

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 or upvote 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