Font properties in ODS Excel

[ADN]

Hi,

I am using SAS ODS Excel to generate excel files with tables. My question is how do I set the font, font size, color and font weight. 

Previously I used something like this in SAS ods excelxp tagset. But that does not seem to be working anymore.

define tot_defects/ display style(header)={font_face="Calibri" font_size=12pt font_weight=bold background=CX2E8B57 foreground=CXFFFFFF just=c}
          style(column)={font_face="Calibri" font_size=10pt just=c};

[Vince_SAS]

What version of SAS are you using?  This worked for me using SAS 9.4 M3 on Windows:

ods _all_ close;

ods Excel file='C:\temp\temp.xlsx';
  proc report data=sashelp.class nowd;
    column name age sex height weight;
    define name / display style(header)=[font_face='Calibri' font_size=12pt font_weight=bold background=CX2E8B57 foreground=CXFFFFFF just=c]
                          style(column)=[font_face='Calibri' font_size=10pt just=c];
  run; quit;
ods Excel close;

Vince DelGobbo

SAS R&D

[ADN]

I am using sas 9.04.01M3P062415

I think the Fonts are not coming as expected. Rest is still fine........

[Vince_SAS · Accepted solution]

I suggest that you open a track with our Technical Support Department:

http://support.sas.com/ctx/supportform/createForm

Be sure to include your code, sample data, and a copy of the SAS log from the code that fails.

Vince DelGobbo

SAS R&D