Output data to a formatted excel file

Question

Hi,

Is there any possibility to output data from Alteryx to a provided formatted excel file including macros and formulas which should not be removed/ touched?
An example: there is a workbook file with multiple tabs provided by an external vendor in their format to transform data provided by us.

Thanks and regards

DawnDuong · Answer

Thank you @MichaelSu . very helpful blog post!

MichaelSu · Answer

also here: https://intersectionsandoverlaps.wordpress.com/2019/09/27/alteryx-excel-templates-with-blob-tools/

MichaelSu · Answer

@DawnDuong  & @KW_S2 ,

I have also seen instances where individuals will use the blob tool in order to output to a pre-formatted excel template. Take a look at the Community post found here:

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Change-the-filenames-of-330-files-based-on-a-certain-ID-in-cell/m-p/469767/highlight/true#M93121

Thanks,

Mike