Output data to a formatted excel file

[KW_S2]

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]

hi @KW_S2 

You can choose to output to specified range in a specified sheet (i.e. replace only hardcoded value). The formatting can be preserved, see discussion in this thread.

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Excel-output-to-formatted-sheet/td-p/5...

good luck,

Dawn.

[KW_S2]

Thank you! It is working great! 🙂

[MichaelSu]

@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-base...

Thanks,

Mike

[MichaelSu]

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

[DawnDuong]

Thank you @MichaelSu . very helpful blog post!