SAS Office Analytics, SAS Add-In for Microsoft Office, and other integrations

Excel tagsets creating rouge cell with different background color

Reply
Super Contributor
Posts: 374

Excel tagsets creating rouge cell with different background color

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;

Grand Advisor
Posts: 10,210

Re: Excel tagsets creating rouge cell with different background color

Yes, same behavior. Also using 9.3 TS1M2

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

SAS Super FREQ
Posts: 8,719

Re: Excel tagsets creating rouge cell with different background color

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

Ask a Question
Discussion stats
  • 2 replies
  • 436 views
  • 0 likes
  • 3 in conversation