Hi, I'm using Excel add-in to run a stored process that runs PROC REPORT to make a table with some traffic lighting. I'm using default settings, and %stpbegin %stpend, so the ODS destination is tagsets.sasreport12. When the report is viewed in Excel I don't see the traffic lighting. If I view the report in EG I do see the traffic lighting. And of course I can see the traffic lighting in the xml: <CSV> "Slipper", " $68,641"; "Sport Shoe", " $1,690"<Value style:color="#FF0000" />; "Women's Casual", " $51,541"; "Women's Dress", " $108,942"; </CSV> Does this mean it is a problem with how Excel interprets the xml? Any useful alternatives for doing traffic-lighting in a way that will work for the add-in? I've got Office Add-in 4.3, Linux server running 9.3, and Excel 2003. I can replicate the problem with just the sample code below. ods tagsets.sasreport12
ENCODING="UTF8"
STYLE=EGDefault
STYLESHEET=(URL="file:///C:/Program%20Files/SASHome/SASAddinforMicrosoftOffice/4.3/Styles/AMODefault.css")
body="~/Junk/TrafficLight.srx"
CHARSET=' '
;
proc report data=sashelp.shoes (obs=10) nowd;
col product sales;
compute sales;
if product="Sport Shoe" then call define
(_COL_ ,'style','style=[foreground=red]');
endcomp;
run;
ods tagsets.sasreport12 close;
Thanks, --Q.
... View more
