More than one style in ods excelXP?

[asantoni]

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? 

[Reeza]

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;