The SAS Output Delivery System and reporting techniques

Adjusting Row Height in ODS ExcelXP output

Reply
New Contributor
Posts: 2

Adjusting Row Height in ODS ExcelXP output

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

Attachment
Attachment
Esteemed Advisor
Esteemed Advisor
Posts: 6,704

Re: Adjusting Row Height in ODS ExcelXP output

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?

SAS Super FREQ
Posts: 8,645

Re: Adjusting Row Height in ODS ExcelXP output

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;

New Contributor
Posts: 2

Re: Adjusting Row Height in ODS ExcelXP output

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

Esteemed Advisor
Esteemed Advisor
Posts: 6,704

Re: Adjusting Row Height in ODS ExcelXP output

Hi,

Try the option: ROW_HEIGHT_FUDGE

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

SAS Super FREQ
Posts: 8,645

Re: Adjusting Row Height in ODS ExcelXP output

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

Attachment
Post a Question
Discussion Stats
  • 5 replies
  • 2124 views
  • 3 likes
  • 3 in conversation