control data font size in excel exported output from ODS tagsets.ExcelXP

[Ronein]

Hello

I want to control font size in all tables that are exported in  ODS tagsets.ExcelXP.

I want to have tables in excel with excel size 8.

What is the way to control data font size in excel exported output from  ODS tagsets.ExcelXP?

Thaks

[Cynthia_sas]

Hi:
The method you use will depend on the procedure you have inside your ODS TAGSETS.EXCELXP "sandwich" -- for PRINT, REPORT or TABULATE -- you can change the font of the output with a simple style override.

Cynthia

Here's an example:

ods tagsets.excelxp file='c:\temp\change_font.xml' style=htmlblue
    options(sheet_name='Print');
  proc print data=sashelp.class (obs=3) noobs
       style(header)={font_face='Courier New' fontsize=8pt fontweight=bold}
	   style(data)={font_face='Courier New' fontsize=8pt};
  run;
  
  ods tagsets.excelxp options(sheet_name='Report');
  proc report data=sashelp.class (obs=3)
       style(header)={font_face='Albany AMT' fontsize=8pt fontweight=bold}
	   style(column)={font_face='Albany AMT' fontsize=8pt};
  run;
  
  ods tagsets.excelxp options(sheet_name='Tabulate');
  proc tabulate data=sashelp.class;
    class sex age / style={font_face='Times New Roman' fontsize=8pt fontweight=bold};
    var height / style={font_face='Times New Roman' fontsize=8pt};
    classlev sex age / style={font_face='Times New Roman' fontsize=8pt fontweight=bold};
    table sex all,
	      age*n*{style={font_face='Times New Roman' fontsize=8pt}};
    keylabel n=' ' 
             all='Total';
	keyword all / style={font_face='Albany AMT' fontsize=8pt fontweight=bold};
    keyword n /style={font_face='Albany AMT' fontsize=8pt fontweight=bold};
run;
ods tagsets.excelxp close;