The SAS Output Delivery System and reporting techniques

Formatting individual cells with ods msoffice2k

Reply
N/A
Posts: 0

Formatting individual cells with ods msoffice2k

Hi - I am trying to use the ods msoffice2k to output an html file to
excel. The code that I have to produce the table in excel is as
follows:
ods MSOFFICE2K path = "C:\test\"
body ='.Review-Summary-Table.xls';
proc print data = tabrev.CY_age_table style(DATA) = {BACKGROUND = #CDC9C9};
title "Age Table Review Summary";
footnote;
run;
ods MSOFFICE2K close;
ods Listing;

This does produce a table with most of the formatting that I specified
but not all. The items in tabrev.CY_age_table style are essentially
either this:



or this:


The correct formatting is applied to items that are like the first -
the text is the color and size that I want. However the formatting is
not applied when items are hyperlinks like the second. Instead, the
hyperlinks appear in the excel default - blue, underlined, unbolded,
and in a slightly smaller font size ignoring all of the font
specifications I indicate. Is there a way to get it so that the
hyperlinks will appear as I specify?

Thanks,
Jeff
Ask a Question
Discussion stats
  • 0 replies
  • 97 views
  • 0 likes
  • 1 in conversation