topic Adjusting Excel row heights with CSS? in ODS and Base Reporting

Adjusting Excel row heights with CSS?

tomcmacdonald — Wed, 20 Dec 2017 19:13:32 GMT

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.

Re: Adjusting Excel row heights with CSS?

ballardw — Wed, 20 Dec 2017 21:41:04 GMT

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?

Re: Adjusting Excel row heights with CSS?

Cynthia_sas — Wed, 20 Dec 2017 22:27:42 GMT

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