topic Re: ods excel row-height for full excel in ODS and Base Reporting

ods excel row-height for full excel

AlexeyS — Sat, 05 Nov 2022 14:46:48 GMT

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

Re: ods excel row-height for full excel

Ksharp — Sun, 06 Nov 2022 09:55:04 GMT

Try "zoom" option.

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

Re: ods excel row-height for full excel

Ksharp — Sun, 06 Nov 2022 09:55:54 GMT

Try "zoom" option.

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

Re: ods excel row-height for full excel

AlexeyS — Mon, 07 Nov 2022 19:21:08 GMT

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?

Re: ods excel row-height for full excel

Ksharp — Tue, 08 Nov 2022 11:36:45 GMT

Maybe @Cynthia_sas know the answer ?