Applying Excel Themes to Alteryx output

[pwerth712]

When I apply a new Excel Theme to my output, the colors do not change in the output generated by Alteryx via Reporting tools. Has anyone figured out a workaround for this that doesn't involve using a Data Output tool? Thanks!

[Qiu]

@pwerth712 
Can you enlighten us a bit more on " Apply Excel Theme", not sure how is it used with Reporting Tools.

[AkimasaKajitani]

Hi @pwerth712 

Have you tried the Render tool?

[danilang]

Hi @pwerth712 

When you use a Render tool to output to an existing excel workbook, all the cells formats are overwritten along with the data.  This includes things like fonts, alternating row colours and other theme related options  As far as I know, there's no way to output only a subset of the formatting options using a Render tool, i.e. change the font, but leave background colours the same.

On the flip side of this, the Output tool should be able to write data only to an existing workbook while preserving formatting.  I say "should" because I've never actually tried it.  It's possible that writing to an existing cell range will preserve formatting but appending new rows will not.

Why do you not want to use an output tool?

Dan   

[pwerth712]

To clarify, when you open the attached file (direct output from Alteryx) and then try to change the Excel theme (Page Layout --> Themes), the colors in the output do not change. 

[Qiu]

@pwerth712 

I think this is because the output table already has its own format and canot be override by Table Styles.

Try to remove the Fill option in your Table Tool or remove it from Excel.