Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.

Output data to a formatted excel file

KW_S2
5 - Atom

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

5 REPLIES 5
DawnDuong
13 - Pulsar
13 - Pulsar

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
5 - Atom

Thank you! It is working great! 🙂

MichaelSu
Alteryx Alumni (Retired)

@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
Alteryx Alumni (Retired)
DawnDuong
13 - Pulsar
13 - Pulsar

Thank you @MichaelSu . very helpful blog post!

Labels