Help using Base SAS procedures

More than one style in ods excelXP?

Reply
N/A
Posts: 1

More than one style in ods excelXP?

I have a general question about ODS excelXP tagset. Is it possible to use two different style options for the same tagset session? That is, are we restricted to one style template per workbook created between “ods tagset.excelXP” and “ods tagset.excelXP close”? For instance, if I want to create one workbook with two worksheets and use two user defined templates for each of the worksheets, is that possible? 

Super User
Posts: 19,770

Re: More than one style in ods excelXP?

No idea, but easy enough to test.

Doesn't seem to change much, but there are some slight changes, eg. alignment of headers. 

ods tagsets.excelxp file="C:\temp\test.xml" style=journal options(sheet_interval="proc");

proc print data=sashelp.class;

run;

ods tagsets.excelxp style=meadow;

proc print data=sashelp.class;

run;

ods tagsets.excelxp close;

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