Export to excel with wrong font

hhchenfx — Tue, 22 Jan 2019 04:10:05 GMT

Hi,

I run this code and the header font and size is correct.

However, the body table has font is Arial with font_size 9.5 instead of Calibri 10.

I run the proc registry and Calibri is listed on log file.

proc registry
startat='core\printing\freetype\fonts'
list
levels=1
;run;

Please help me to fix it.

Thank you so much.

HHCFX

ods listing close;
ods excel file="C:\Users\_temp\exp6.xlsx"   
                    options (sheet_interval = "none" sheet_name = "T7" );

	proc report data=T7_short nowd
	STYLE(Header)={background=charcoal foreground=white }		/*top row*/
     	style(header)={font_face="Times New Roman" font_size=11pt}
     	style(report)={font_face="Calibri" font_size=11pt};

		column project_code	Total_cost total_hour ;


		compute Total_cost;
		call define (_col_,"style","style={background=gray}");
			endcomp;

		compute total_hour;
		call define (_col_,"style","style={background=lightgray}");
			endcomp;

		run;
ods excel close;

Re: Export to excel with wrong font

Cynthia_sas — Tue, 22 Jan 2019 15:07:52 GMT

Hi:
Style(report) will NOT change the data cells. Have you tried style(column) instead? You usually use style(report) for table level settings like interior tables lines, whether there's a frame around the table and overall table width, etc.

Cynthia

topic Export to excel with wrong font in ODS and Base Reporting

Export to excel with wrong font

Re: Export to excel with wrong font