05-17-2013 09:03 AM
I am using the below code in stored process to generate an excel output as well as html output.
filename mycsv catalog "&_TMPCAT..myfile.csv"; ods csv body=mycsv rs=none;
footnote '<a href="' &_REPLAY 'myfile.csv">Open in Spreadsheet </a>';
ods csv close;
Problem : When I access the stp file from excel sas addin, I am getting the output fine with no issues. However I am loosing out on the _odsstyle resolution alike html. Can I add anything extra with
ods csv body=mycsv rs=none; to make the excel output a little bit colorful. May be make the headers bold, put some colors in the background (alike festival option) ?
Any help would be much appreciated.