Excel sheets highlight on Alteryx output

[NiranjanK1]

Hi All,

Is there a way to highlight excel sheets in Alteryx output. Please find the below screenshot for reference. I need to build output the same format. Please suggest me if any possibilities. 

thanks,

Navin

[DavidSkaife]

Hi @NiranjanK1 

You shouldn't need to use Alteryx to highlight the tabs; if you have a preformatted excel workbook and you use the option 'Overwrite Sheet or Range' that should preserve the formatting.

Edit: just tested it and it didn't work 🤔 but if you define a named range on the sheet instead it works. See updated highlighted screenshot above

[smoskowitz]

Hi @NiranjanK1 --

There isn't a native way of doing what you ask, but if the templates can be created beforehand, you can do something like what is outlined in the below article.

https://intersectionsandoverlaps.wordpress.com/2019/09/27/alteryx-excel-templates-with-blob-tools/

or

The Blob: Reporting That Isn’t From a Horror Film - Alteryx Community

Thanks,

Seth

[messi007]

@NiranjanK1,

I don't think that you can do it with alteryx. However you have two options :

- Prepare an empty Excel file with colored sheets and then inject the data with perserve formating option :

- Do it with VB script

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/How-to-input-only-colored-sheets-from-...

Hope this helps,

Regards,

[NiranjanK1]

@DavidSkaife @messi007 Thanks for the reply. Let me try with existing template, i will try to replace with data.