Output to all .xlsx files in a folder

[gckplatt]

I have a universal sheet I need to add to all files in a folder. Is there a way to output a sheet to all .xlsx files in a folder? I tried the path location *.xlsx and it did not work.

[gckplatt]

This is a basic table with a render after it

[summit_view]

Hi @gckplatt 

You would need to use an Output Data tool rather than a Render tool.  The render tool would replace all sheets in a workbook.  With the Output Data tool you can just add a single sheet to what is already there (need to specify sheet name).  To have this apply to all files in a folder, I would probably use a directory tool which feeds into a batch macro.  Someone may have a way to do it without a macro, but that would be my approach.

[gckplatt]

Can I use an Output Data tool after the basic table and the table will still keep its proper format?

[summit_view]

The Output Data tool has the option to "Preserve Formatting on Overwrite".  Depending on how many files you have (and how consistent the output is), you could setup the formatting in excel after the first write.  To do this you would setup your data using normal Alteryx tools and not the Table Tool.  If you wanted to use the render tool and a table tool, I believe you'd have to read in all the tabs for each file, setup the formatting for all tabs in Alteryx and the write out all the tabs for each file.

Unfortunately, the Render tool and Output Data tool only each provide half the needed functionality in many cases, which I often find frustrating.