exprting excel without cell color

[SanjayM]

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

[Cynthia_sas]

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