In reply to Eric.

Hi Eric, thanks for your feedback and great questions. It is possible to customize Excel style to control your data cells' font name, size and color. You would need to add another STYLE statement to the PROC TEMPLATE, here is an example:

style data from data /
color = #FF0000
fontsize=5
fontfamily='Times New Roman'
;

In order to have visible grid lines, you would need to remove the background color (grey) of the worksheet. This is done by the BACKGROUNDCOLOR= (alias BACKGROUND=) attribute set to _UNDEF_ for the BODY style element. Here are a couple examples:

/* 1 */
class body /
background=_undef_;

/* 2 */
style body /
background=_undef_;

See also discussion on using CLASS vs. STYLE.