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!
@pwerth712 Can you enlighten us a bit more on " Apply Excel Theme", not sure how is it used with Reporting Tools.
Hi @pwerth712
Have you tried the Render tool?
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
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.
