BookmarkSubscribeRSS Feed

ODS MARKUP: add the ability to modify the worksheet tab colors with the ExcelXP tagset

2 Comments
BobWilcox
Fluorite | Level 6

I'm trying to accomplish this same requirement, has this been addressed yet?

ChrisHemedinger
Community Manager
Status changed to: Suggestion Implemented

This is possible now in ODS EXCEL with the TAB_COLOR option.  See doc for ODS EXCEL.

 

ods excel file="c:\temp\temp.xlsx"
  options(tab_color="red" sheet_interval="proc");

proc print data=sashelp.class;
where sex='M';
run;

 

ods excel options(tab_color="green");
proc print data=sashelp.class;
where sex='F';
run;

 

ods excel close;