ods excel row-height for full excel

[AlexeyS]

Hi All,

I have two questions :

1. When i use ods excel to export excel, i want to update the height of rows. I tried two methods : absolute_row_height and row_heights. In both, i get the same result, The rows that comes directly after the data are different than the height i fixed. For example, if my data contains 100 rows, and i used absolute_row_height ='16' then the first 100 rows height will be 14.25 and the rows after the first 100, will be different.

How can i fix the the height of row for all rows in excel? 

2. Because i live in Israel, when i export to excel using ods excel, i get my data is from right to left. How can i change the data to left to right?

Thank you,

Alexey

[Ksharp]

Try "zoom" option.

ods excel file='c:\temp\temp.xlsx' options(zoom='200');
proc report data=sashelp.class nowd;
run;
ods excel close;

[AlexeyS]

Excuse me, but it doens't help, because still when i have the data, the row height is defined as i determined, but from the row where no data, the row height is different. How can i define row height is equal for worksheet?

[Ksharp]

Maybe @Cynthia_sas know the answer ?

[Ksharp]

Try "zoom" option.

ods excel file='c:\temp\temp.xlsx' options(zoom='200');
proc report data=sashelp.class nowd;
run;
ods excel close;