topic Re: tagsets.ExcelXP align and wrap in ODS and Base Reporting

tagsets.ExcelXP align and wrap

deleted_user — Wed, 11 Mar 2009 08:48:17 GMT

Hi,

I'm creating an Excel sheet using the ODS tagsets.ExcelXP.

But two things just won't work....

First the alignment of cells. Example:
[PRE]
PROC REPORT DATA=sashelp.class ;
COLUMN _ALL_ ;
DEFINE sex /STYLE(COLUMN)=[just=center] ;
RUN ;
[/PRE]
The style element "just=center" does nothing in the Excel sheet.

Second the wrapping of cells. It's standard with the column headers but not within a table.

Can anyone help me with this?

Thnx,
Thierry

Re: tagsets.ExcelXP align and wrap

Eric_SAS — Wed, 11 Mar 2009 16:39:48 GMT

Which version of the Excelxp tagset are you using?

It should say in the log. If it doesn't say, then it is very old.

You can get the latest tagset here.

http://support.sas.com/rnd/base/ods/odsmarkup/

Re: tagsets.ExcelXP align and wrap

Cynthia_sas — Wed, 11 Mar 2009 19:24:21 GMT

Hi:
When I run this code:
[pre]
ods tagsets.excelxp file='c:\temp\try_cntr.xls'
style=sasweb
options(absolute_column_width="20,15,15" doc="Help");

proc report data=sashelp.class nowd
style(column)={just=center};
column name age height;
run;

ods tagsets.excelxp close;

[/pre]

I do see centering (in Excel 2007). Sometimes, you have to make the columns "bigger" in order to see the impact of centering.
I am running the version of the ExcelXP tagset template dated:
[pre]
NOTE: This is the Excel XP tagset (SAS 9.1.3, v1.75, 07/26/07). Add options
(doc='help') to the ods statement for more information.

[/pre]

(from my SAS log)
cynthia

Re: tagsets.ExcelXP align and wrap

deleted_user — Thu, 12 Mar 2009 07:26:09 GMT

Hi,

Thanks for your reply.

When I run Cynthia's code the centering doesn't work.
I guess it's because the old version of the tagsets I'm using.

I'm using the version:
[pre]
NOTE: This is the Excel XP tagset (SAS 9.1.3, v1.28, 08/29/05). Add options(doc='help') to the ods statement for more information.
[/pre]
I'll update the Tagset and try again.

The wrapping of cells? Is there an option for?

Thanks!
Thierry Message was edited by: TH