Desktop productivity for business analysts and programmers

exprting excel without cell color

Reply
Frequent Contributor
Posts: 97

exprting excel without cell color

Hi am using the below mentioned code to export the output to an excel file. The cells are shaded with some colour.

ods msoffice2k file= "/apps/sas/ReportsRepository/Reports/BSS/BMA/CSV/Monthly/myexcelfile.xls" ;

proc report data=WORK.QUERY8283 nowd headskip split='*' spacing=1;

How can I supress the cell background colouring
SAS Super FREQ
Posts: 8,820

Re: exprting excel without cell color

Hi:
Try using different style templates. STYLE=MINIMAL is a very plain style.
[pre]
ods msoffice2k file= "/myexcelfile.xls" style=MINIMAL;
...
ods msoffice2k close;
[/pre]

In that way, the HTML file that you create and open with Excel will have some bolding in the column headers (if I remember correctly) but there are no colors, otherwise.

cynthia
Ask a Question
Discussion stats
  • 1 reply
  • 113 views
  • 0 likes
  • 2 in conversation