Its kind of weird that i could not find Excel as a sink. How to write the file to Excel using DataFactory?
2
Excel is yet not a supported sink in Azure data factory. Its is not an out of box functionality You would have to write your own custom logic either via Azure function,logic app etc
I have never used, but it seems this company is sharing for free a package that you can install in your ADF instance to export Excel files.
https://invati.ai/software-development-accelerators/excel-writer-for-azure-data-factory/
Note that although the package is free, hosting it in your Azure instance may incur in charges.
Click here to cancel reply.
2
Answers
Excel is yet not a supported sink in Azure data factory.
Its is not an out of box functionality
You would have to write your own custom logic either via Azure function,logic app etc
I have never used, but it seems this company is sharing for free a package that you can install in your ADF instance to export Excel files.
https://invati.ai/software-development-accelerators/excel-writer-for-azure-data-factory/
Note that although the package is free, hosting it in your Azure instance may incur in charges.