Issues while using ODS Excel XP in EG

[Cynthia_sas]

Hi:
About #2...the only way I know to get the empty cells above region or product formatted is to set the default for ALL the headers to the color you want those cells (black/white) and then override all the other headers in DEFINE statements to be the other colors you want.

cynthia
[pre]
ods listing close;
ods tagsets.ExcelXp file='header_ques.xls' style=sasweb
options(embedded_titles='yes' sheet_name='Business Unit HA' absolute_column_width='9');
title 'make ALL headers white and black and then override the ones you want different';
proc report data=sashelp.shoes nowd
style(headers)={foreground=black background=white font_weight=bold};
where product in ('Boot', 'Sandal', 'Slipper');
column region product, ( sales inventory returns);
define region / group;
define product / across style(header)={foreground=white background=green};
define returns/ sum ;
define inventory / sum style(header)={foreground=black background=cyan};
define sales / sum style(header)={foreground=black background=cyan};
run;
ods _all_ close;[/pre]