BORDER in ODS EXCEL

draroda — Wed, 30 May 2018 06:02:32 GMT

Hi All,

I am looking for borders around each cell in my ODS excel output.

Below is template style i am using from but could not get through.

proc template;
 define style styles.journal_borders;
 parent = styles.journal;
 style header from header/
 font_weight = bold
 foreground = #CC99FF
 background=yellow
 ;

 style header_right from header /
 borderrightstyle=solid
 borderrightcolor=black
 borderrightwidth=2
 ;
 style header_bottom_right from header_right /
 borderbottomstyle=solid
 borderbottomcolor=black
 borderbottomwidth=2
 ;
 style header_thinbottom_right from header_right /
 borderbottomstyle=solid
 borderbottomcolor=black
 borderbottomwidth=1
 ;
 style header_bottom from header /
 borderbottomstyle=solid
 borderbottomcolor=black
 borderbottomwidth=2
 ;
 style data_bottom from data /
 borderbottomstyle=solid
 borderbottomcolor=black
 borderbottomwidth=1
 ;
 style data_bottom_right from data_bottom /
 borderrightstyle=solid
 borderrightcolor=black
 borderrightwidth=2
 ;
 end;
run;

Please guide.

Re: BORDER in ODS EXCEL

RW9 — Wed, 30 May 2018 07:57:58 GMT

Have you looked at the various posts on this, for example:

https://communities.sas.com/t5/ODS-and-Base-Reporting/ExcelXP-controlling-borders-not-like-other-ods-destinations/td-p/66766

http://support.sas.com/resources/papers/proceedings12/095-2012.pdf

It should work, maybe you can present an example of your full code, using sashelp.class?

Also tell us what version of SAS you are using, unix/windows etc.

topic BORDER in ODS EXCEL in ODS and Base Reporting

BORDER in ODS EXCEL

Re: BORDER in ODS EXCEL