topic Re: ODS EXCEL setting borders in ODS and Base Reporting

ODS EXCEL setting borders

pfvk — Sat, 04 Feb 2023 04:09:16 GMT

Hi,
I'm trying to use ODS EXCEL to output my dataset.
Below is an example of my code.

data test;
	input ID$ age;
	cards;
	A 23
	B 99
	C 87
	;
run;

ods excel file="age.xlsx"  options(sheet_name="test");
proc report data=test
	style(header)=[background=white font_face="Calibri" foreground=black]
	style(column)=[font_face="Calibri"]
nowd;
run;
ods excel close;

The result is like the below picture, the background borders are not displayed.

I would like to keep all the borders like the one below, how can I modify my code?
Thanks in advance.

Re: ODS EXCEL setting borders

Ksharp — Sat, 04 Feb 2023 09:30:03 GMT

ods excel file="c:\temp\age.xlsx"  options(sheet_name="test") style=minimal;
proc report data=test
	style(header)=[ font_face="Calibri"]
	style(column)=[font_face="Calibri"]
nowd;
run;
ods excel close;

Re: ODS EXCEL setting borders

pfvk — Sat, 04 Feb 2023 10:07:29 GMT

Thanks for your help!
I have a small question. Is there any reference including all meanings of "style" in ODS EXCEL?

Re: ODS EXCEL setting borders

Ksharp — Sat, 04 Feb 2023 10:11:42 GMT

If you want see what things in STYLE.MINIMAIL ,Try this :

proc template;
source styles.minimal;
run;