Hello
I have SAS version 9.4. I am using the tagsets.ExcelXP to export data to an Excel workbook and want to change the tab color. According to items I've read, the option of tab_color('color') should work, allowing for the word of the color i.e. 'green' or the hexadecimal value. Below is my code but the tab_color function doesn't work (everything else does).
I found some code from the SAS website to edit the template and create tagsets.ExcelXP_mod which allows for tabcolor= but it seems to only allow names i.e. 'red', 'green' but not hexadecimal or other descriptions for the color. All assistance greatly appreciated.
options center;
ods listing close;
ods tagsets.ExcelXP path=&T_Path
file=&F_Name style=printer;
title 'DAD_DQ';
/*Worksheet 2 - demographics*/
ods tagsets.ExcelXP options(sheet_name='Demo' Absolute_Column_Width='5,8,8,8,8,12,8,8,8,8'
Autofit_height='yes' tab_color='green');
proc print data=demo_1 noobs style(Data)=[just=left] style(Header)=[just=center];
var inst;
var chartno;
var acctno;
var disdate;
var coder/style(data)={tagattr='format:@'};
var HCN/style(data)={tagattr='format:@'};
var Postal;
var Rescode/style(data)={tagattr='format:@'};
var ProvIss;
var RFP/ style(data)={tagattr='format:@'};
run; quit;
ods tagsets.ExcelXP close;
