How to set the font size in line statement while reporting in excel i.e. using ods tagsets.excelxp?

[krishnaboosireddi]

Hi ,

How to set the font size in line statement while reporting in excel i.e. using ods tagsets.excelxp?

I used font_size=10pt and font=(Arial,10pt) in style's any of this didn't work.

The below is the code how i used :

compute before <variable>/style={font=(Arial,10pt) font_weight=bold just=l};

length myline $85;

myline=<variable>;

line myline $ 85.;

endcomp;

compute before <variable>/style={font_size=10pt font_face=Arial font_weight=bold just=l};

length myline $85;

myline=<variable>;

line myline $ 85.;

endcomp;

just=l is working and the remaining is not working.

Can you guys please help me out with this?

Thanks,

Reddi krishna

[Cynthia_sas]

Hi:

  I find that concrete code always helps. When I run this code (below) I see a color of cyan and a font of 14pt Arial, bold. (Using SAS 9.3, Excel 2010 and either TAGSETS.EXCELXP or MSOFFICE2K.

cynthia

ods tagsets.excelxp file='c:\temp\tryxp.xml' style=sasweb;

ods msoffice2k file = 'c:\temp\trymso.xls' style=sasweb;

proc report data=sashelp.class nowd;

  column age name height weight;

  define age / order;

  compute before age/

    style={font_size=14pt font_face=Arial foreground=cyan

           font_weight=bold just=l};

    length myline $85;

    myline='This is a test string for: '||put(age,2.0);

    line myline $85.;

  endcomp;

run;

ods _all_ close;