topic Re: Ods excel right to left in SAS Programming

Ods excel right to left

romanvi — Tue, 23 May 2023 17:28:08 GMT

Is there a way to control the direction of the table opened in the sheet using ods excel? The default is from left to right and i want to change it to right to left.

Re: Ods excel right to left

JosvanderVelden — Fri, 26 May 2023 09:03:27 GMT

Have a look at this thread: https://communities.sas.com/t5/ODS-and-Base-Reporting/displaying-excel-sheet-from-right-to-left/td-p/124175

Re: Ods excel right to left

romanvi — Tue, 30 May 2023 13:47:24 GMT

Thanks but it's impossible to download the version attached.

Re: Ods excel right to left

SASKiwi — Tue, 30 May 2023 21:12:01 GMT

If you are opening the Excel workbook with Excel, have you tried this display option?

Re: Ods excel right to left

romanvi — Wed, 31 May 2023 02:02:38 GMT

Yes.

Re: Ods excel right to left

SASKiwi — Wed, 31 May 2023 02:07:26 GMT

And does it do what you want?

Re: Ods excel right to left

JosvanderVelden — Wed, 31 May 2023 09:28:10 GMT

Microsoft info on RTL support can be found here: https://support.microsoft.com/en-us/office/using-right-to-left-languages-in-office-17d8a34d-36d6-49ad-b765-257cb7cd22e2
Maybe @EyalGonen can help in providing the current link to download the XPtagset that has the "RTL" option.

Re: Ods excel right to left

EyalGonen — Wed, 31 May 2023 09:31:43 GMT

Hi @JosvanderVelden

Try out this code:

options bidi=yes;

ods excel file="d:\temp\test.xlsx" ;

proc print data=sashelp.class;
run;

ods excel close;

Re: Ods excel right to left

romanvi — Wed, 31 May 2023 09:31:49 GMT

No 🙂

Re: Ods excel right to left

romanvi — Wed, 31 May 2023 10:02:11 GMT

Eyal's solution worked!
Options bidi=yes.
Thank's alot.