tagsets.excelXP - column headings in row 1 of spreadsheet

[Harry]

When PROC PRINTing to tagsets.excelXP, the column labels take up rows 1-n depending on how the column headings are split.

I've read through the tagset options and don't see anything that allow me to confine the column headings to row 1 in the file. Is it possible?

TIA

[Cynthia_sas]

Do you have an example of the code you're using or can you duplicate the behavior by using SASHELP.CLASS???? If your labels are too long, they might wrap over to a second row. I am just having a hard time visualizing what you mean by "the column labels take up rows 1-n" depending on the how the headings are split.

When I use the program below, all my column headings are ONLY in Row 1.

cynthia
[pre]
ods tagsets.excelxp file='c:\temp\splithead.xls' style=sasweb;

proc print data=sashelp.class split='/';
var name age height;
label name = 'The/Name'
Age = 'The/Age'
Height= 'The/Height';
run;

ods _all_ close;
[/pre]

[Harry]

Thanks Cynthia. Found my problem. The _odsdest assignment was inside a macro, hence not global, hence not available to %stpbegin, hence HTML destination and not tagsets.excelXP as I assumed it was. Mea culpa. ;-(