Ods excel right to left

[romanvi]

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.

[JosvanderVelden]

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

[romanvi]

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

[SASKiwi]

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

[JosvanderVelden]

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-49a...
Maybe @EyalGonen can help in providing the current link to download the XPtagset that has the "RTL" option.

[EyalGonen · Accepted solution]

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;

[romanvi]

Yes.

[SASKiwi]

And does it do what you want?

[romanvi]

No 🙂

[romanvi]

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