topic Re: Excel tagsets creating rouge cell with different background color in Microsoft Integration with SAS

Excel tagsets creating rouge cell with different background color

ScottBass — Wed, 08 Oct 2014 05:20:36 GMT

SAS 9.3 (TS1M2)

Excel 2007 32-bit

Hi,

When I run the below code, I get a rouge cell at the end of the data (A21) which has a background color of gray instead of white. This is problematic when the worksheet is printed.

Do you get the same results? If so, any idea how to get SAS to play nicely?

Thanks,

Scott

ods _all_ close;

ods noresults;

ods noproctitle;

ods tagsets.excelxp

file="c:\temp\temp.xml"

style=statistical

options(

sheet_interval='none'

frozen_headers='yes'

autofilter='all'

);

ods tagsets.excelxp

options(

sheet_name='Class'

);

proc print data=sashelp.class noobs label

style(header)={

just=left

font_face="Marriott Light"

font_size=11pt

bordertopwidth=1

borderbottomwidth=1

borderleftwidth=1

borderrightwidth=1

}

style(data)={

font_size=10pt

font_face="Marriott Light"

bordertopwidth=1

borderbottomwidth=1

borderleftwidth=1

borderrightwidth=1

}

split='*'

;

run;

ods _all_ close;

ods listing;

Re: Excel tagsets creating rouge cell with different background color

ballardw — Wed, 08 Oct 2014 15:03:32 GMT

Yes, same behavior. Also using 9.3 TS1M2

But if I use Style=Journal it isn't there.

Re: Excel tagsets creating rouge cell with different background color

Cynthia_sas — Sun, 30 Nov 2014 17:34:49 GMT

Hi:

This seems to be an issue using style=statistical. Not sure why. That would be a question for Tech Support. But with almost any other style, the cell at the end of the data is not colored (in my 9.4 test, using Office 2013, the colored cell was light gray).

cynthia