left align TOC in tagsets.excelXP

[deleted_user]

for the html destination usage note 23395 shows how to left align all info in the Table of Contents (http://support.sas.com/kb/23/395.html).
Is there any prospect of getting something like this working for tagsets.excelXP ?

PeterC

[Eric_SAS]

The index=yes option will create a left aligned index of worksheets in the first worksheet.

Is that what you want?

Eric

[deleted_user]

Thank you,
that index= yes option provides a great start.
It condenses the links into just one column.

ODS allows the statement option Contents= and statement ODS ProcLabel= to customize text in a ToC. It would be nice if this was also used on the Worksheets tab created by Index='yes'.

The big feature is the ability to control text on a ToC

I used this model code to show the comparison[pre]
ods _all_ close ;
ods tagsets.excelxp file=odsout( url=none) rs=none
options(index='yes' contents='yes'
Embedded_Titles='YES' Embed_Titles_Once='No' )
;
title 'class' ;
proc sort data= sashelp.class out= class; by sex ;
title2 j=r 'class in page dim';
ods tagsets.excelxp options( sheet_name='ClassTable' );
ods proclabel='A';
proc tabulate format= best5. contents='2';
var height weight ;
class age sex ;
table age all, mean*( height weight )
/ contents= '3' ;
run;
title2 j=r 'by statements' ;
ods tagsets.excelxp options( sheet_name='PageBy' );
ods proclabel='B';
proc tabulate format= best5. contents='4';
var height weight ;
class age sex ;
table sex all
, age all, mean*( height weight )
/ contents= '5' ;
by sex ;
run;
title2 j=r 'proc print' ;
ods tagsets.excelxp options( sheet_name='ListBy' );
ods proclabel='P';
proc print contents='6'; by sex ; run;
ods _all_ close ; [/pre]


Appreciating the support

PeterC