topic What attributes can be changed in ExcelXP in ODS and Base Reporting

What attributes can be changed in ExcelXP

OS2Rules — Fri, 30 Jun 2006 16:20:04 GMT

Hi All:

I'm using the ExcelXP tagset to create a number of multi-tab spreadsheets. The user has some very specific design requirements for these and I am having some problems getting them just right.

For example, the user wants to 'right justify' the word 'Subtotals:' on the sheet. I'm using a COMPUTE block to output the subtotal but I'm not sure how to justify the text in the cell. (I'm using a CALL DEFINE to provide font, background, and format already).

Is there a comprehensive list of the attributes that can be changed in the tagset using the 'CALL DEFINE'? Do I use the SAS format (".J=Right"), the HTML format ("align=right") or the XML format ("ss:Horisontal="Right")? If the attribute was not assigned to the "style", can it be altered by a CALL DEFINE statement?

Re: What attributes can be changed in ExcelXP

Chevell_sas — Wed, 05 Jul 2006 15:53:39 GMT

One way that this can be done is to apply the styles in the template. The style element created in the template can then be used with the STYLE= parameter of the CALL DEFINE statement.

proc template;
define style styles.test;
parent=styles.default;
style right from data /
font_size=8pt
background=red
just=right;
end;
run;

ods tagsets.excelxp file="temp1.xls" style=styles.test;

proc report data=sashelp.class nowd;
column name age sex height weight;

compute sex;
if sex="F" then call define(_col_,"style","style=right");
endcomp;

run;

ods tagsets.excelxp close;

Re: What attributes can be changed in ExcelXP

Cynthia_sas — Thu, 06 Jul 2006 16:24:47 GMT

chevell:
I thought .r was already defined or will that not work for ExcelXP????
cynthia