Alteryx Designer Discussions

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

Looking for a way to get collums to auto fit after output as well as putting colors on tab

maddoxs
6 - Meteoroid

Is there a way to get the collumns to auto fit so we will not have to format when opening a excel spreadsheet? Also is coloring the bottom sheet tabs possible?

maddoxs_0-1660143056754.png

 

2 REPLIES 2
AlteryxUserFL
11 - Bolide

You will not be able to do both of those with Alteryx alone. You will need a VBA Script / Macro that Alteryx can trigger after the data is written to the file. There are a number of post dedicated to running VBA with Alteryx so no need to rehash here, but below is the link to one of the most useful IMO. 

 

Alteryx Run Command: Executing Excel Macros (VBA) - Alteryx Community 

Luke_C
16 - Nebula
Labels