Hi:
I understand, however, Header borders are CELL-level borders. You are trying to change TABLE-level borders. Just because you can change CELL-level borders in the ExcelXP destination, does not mean that Excel will correctly render TABLE-level borders.
I think it's worthwhile to test whether ODS HTML respects your TABLE level borders as a problem-solving/debugging technique. If ODS HTML shows the TABLE-level borders, but Excel does not, then the problem is NOT with SAS or PROC REPORT. This is useful information.
For example, when I try this code which has RED TABLE-level borders and YELLOW CELL-level borders, I see RED and YELLOW in the HTML output, but I only see YELLOW in the ExcelXP output. This leads me to believe that the issue is with Excel. Sending the information via PROC REPORT overrides in this instance would be the same as sending style info to Excel via a style template.
I don't know whether there's a way to change TABLE-level borders in Excel. This may be a question for Tech Support.
cynthia
[pre]
ods html file='c:\temp\test_border.html' style=styles.sasweb;
ods tagsets.excelxp file='c:\temp\test_border.xml'
style=styles.sasweb;
proc report data=sashelp.class(obs=3) nowd
style(report)={borderrightstyle=solid borderrightwidth=5 borderrightcolor=red
borderleftstyle=solid borderleftwidth=5 borderleftcolor=red
borderbottomstyle=solid borderbottomwidth=5 borderbottomcolor=red
bordertopstyle=solid bordertopwidth=5 bordertopcolor=red}
style(header)={borderrightstyle=solid borderrightwidth=5 borderrightcolor=yellow
borderleftstyle=solid borderleftwidth=5 borderleftcolor=yellow
borderbottomstyle=solid borderbottomwidth=5 borderbottomcolor=yellow
bordertopstyle=solid bordertopwidth=5 bordertopcolor=yellow};
column name age height;
run;
ods _all_ close;
[/pre]