topic Re: Adjusting Row Height in ODS ExcelXP output in ODS and Base Reporting

Adjusting Row Height in ODS ExcelXP output

IamSam — Fri, 20 Jun 2014 10:44:02 GMT

Configuration : ( SAS 9.3 TS Level1M2 running on X64_7PRO platform ) ; MS Excel 2007 ; ExcelXP Tagset version v1.130, 08/02/2013

I have modified the STATISTICAL parent style into one of my own (refer template.sas). This is being used with other macros (refer scorecard.sas) to produce the output ScorecardResults.xls. It seems that despite the 'height=1.5in" specification for table header, SAS ignores it while producing the output. Can you help me understand why.

To be clear on my end objective - example - tab named 'Population Stability', the header row height is 14. Suppose, I want to make this double, that is 28.

Cheers

Abhishek

Re: Adjusting Row Height in ODS ExcelXP output

RW9 — Fri, 20 Jun 2014 11:55:21 GMT

Have you tried setting the AUTOFIT_HEIGHT option, and ROW_HEIGHTS?

I am not sure there is such an options as height in templates, at least I can't find it in the templates I was looking at?

Re: Adjusting Row Height in ODS ExcelXP output

Cynthia_sas — Fri, 20 Jun 2014 14:27:56 GMT

Hi:

SAS did not ignore your HEIGHT= option. To prove this, run simplified code as shown on the attached screen shot. As you can see from the output, your approach works just fine in destinations that respect the SAS setting. But Excel has certain defaults for column width and row height and no matter what you set in the style template, when you are sending report output to Excek, you have to look for other ways, such as the AUTOFIT_HEIGHT suboption and the ROW_HEIGHTS suboption to get Excel to pay attention to your changes.

cynthia

Re: Adjusting Row Height in ODS ExcelXP output

Cynthia_sas — Fri, 20 Jun 2014 14:34:37 GMT

Hi, You are exactly right. These 2 sub-options, specific to TAGSETS.EXCELXP, will make the table header row higher.

Cynthia

ods tagsets.excelxp file='c:\temp\testht2.xml' style=styles.htmlblue

options(doc='Help' row_heights='75,0,0,0,0,0,0' autofit_heights='no');

proc print data=sashelp.class;

run;

ods _all_ close;

Re: Adjusting Row Height in ODS ExcelXP output

IamSam — Tue, 24 Jun 2014 09:13:43 GMT

Thanks for your suggestions. Is there a way to implement such features through a 'style' definition? I had shared the custom template that I am using. In that I want to make the header of all data tables to be wider.

I am using a series of macros that will produce many tables - specifying row_height in each of them separately is not feasible.

The way I can specify

class Header /

vjust=m

cellpadding = 10

height = 1.5in

bordercolor = cxB0B7BB

backgroundcolor = cxEDF2F9

color = cx112277;

Is there any option to increase the row height?

Thanks

Abhishek

Re: Adjusting Row Height in ODS ExcelXP output

RW9 — Tue, 24 Jun 2014 09:29:09 GMT

Hi,

Try the option: ROW_HEIGHT_FUDGE

Also refer to the ExcelXp documentation at: Base SAS: Quick Reference for TAGSETS.EXCELXP Tagset