topic Re: color code excel tabs in ODS and Base Reporting

color code excel tabs

NJGIRL — Mon, 14 Sep 2020 16:58:38 GMT

Hi all,

Can anyone direct me to a former post that has example logic on how to color code Excel tabs in ODS?

The following is my code thus far: Thanks!

ods tagsets.ExcelXP file="&output_name" style=Printer;

ods tagsets.ExcelXP options(orientation='landscape'

autofit_height='Yes'

autofilter='all'

sheet_name="Exposure XXX"

embedded_titles='yes'

embedded_footnotes='yes'

row_repeat='7'

frozen_headers='7'

width_points='10'

width_fudge='1'

zoom='80'

scale='60'

center_horizontal='Yes'

gridlines='Yes'

print_header='&L &A &C &D &T &R Page &P of &n'

print_footer="&program_name." );

Re: color code excel tabs

mklangley — Mon, 14 Sep 2020 19:22:40 GMT

From this SAS support page, try using the TABCOLOR option:

tabcolor='blue'

Re: color code excel tabs

NJGIRL — Tue, 15 Sep 2020 14:21:41 GMT

Darn, no luck:Unrecognized option: TABCOLORUnrecognized option: TAB_COLOR
As you can see I tried with/without the underscore.
I wonder if this is an underlying issue with the Proc Template style we are using ? ?

Re: color code excel tabs

Cynthia_sas — Tue, 15 Sep 2020 15:04:30 GMT

Hi:
For that code in the note to work, you have to download the tagset template code in the link, run that to create tagsets.ExcelXP_mod, as shown in the code. When I tried it, tabcolor= suboption worked for me with the modified tagset template, as shown below:

I believe that ODS EXCEL uses the tab_color suboption. You'd have to check the documentation. When I tried this (using tab_color with ODS EXCEL), it worked for me:

Cynthia

Re: color code excel tabs

NJGIRL — Wed, 16 Sep 2020 14:25:08 GMT

Thanks Cynthia!