Adjusting Excel row heights with CSS?

[tomcmacdonald]

My CSS file looks like this

tbody tr {
   height: 25px;
}

My SAS code looks like

ods excel file=test.xlsx cssstyle=&cssstyle;

proc print data=foo noobs;
run;

ods excel close;

It doesn't seem to have any effect on row heights.

[ballardw]

What is the value of the macro variable &cssstyle?

PX may be a less than ideal unit of measure as PX is dependent on screen resolution  and the file created likely wouldn't know the screen resolution. Have you tried setting an measure such as IN or CM for constant height or PCT if you need some that changes per screen size or resolution?

[Cynthia_sas · Accepted solution]

Hi:

  I can't remember if ODS EXCEL uses CSSSTYLE option. That is a question for Tech Support and they will want to see the whole CSS file.

  But within ODS EXCEL, you can use the ROW_HEIGHTS sub-option to alter the row heights. It is in the doc. For example, here, I made only the headers taller.

cynthia