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
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
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
@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-excel-file/td-p/446798
Hope this helps,
Regards,
@davidskaife @messi007 Thanks for the reply. Let me try with existing template, i will try to replace with data.
