ODS EXCEL---Excel sheet layout-right to left

Ronein — Tue, 10 Jun 2025 11:03:31 GMT

Hello

I am running ods excel and also send it to email.

The XLSX sheets layout is from left to right and i want to change to right to left.

What is the way to do it?


%let Reportpath="/usr/local/SAS/SASUsers/LabRet/UserDir/udclk79/MYCARS.xlsx";


ods excel file=&Reportpath. 
options  (sheet_name='REPORT1'
embedded_titles='yes' 
embedded_footnotes='yes'
sheet_interval="proc"   /***One table in sheet**/
gridlines = 'yes'
tab_color="YELLOW"
);
proc report data=sashelp.cars contents="Honda Cars";
	  where Make="Honda";
	  column ("Car" make model) ("Cost" msrp invoice) 
           ("Fuel Efficiency" mpg_city mpg_highway);  
run;

ods excel options (sheet_name='REPORTS2'  
sheet_interval="proc"  /**One table in sheet***/
gridlines = 'yes'
tab_color="YELLOW"
);
proc report data=sashelp.cars contents="All Cars" 
spanrows; /* 2 */
	define Make / order;
	define Model / order;                       
	column Make Model MSRP MPG_City Horsepower;
run;

ods excel close;

/****SEND EMAIL****/
/****SEND EMAIL****/
FILENAME mail EMAIL 
from="Ron.Dave@gmail.com"
TO=("Ron.Dave@gmail.com")
SUBJECT="CAR REPORTS"
encoding='utf-8'  /**To show Hebrew!!!**/
CONTENT_TYPE="text/plain" 
attach=(&Reportpath. content_type="excel");
ODS LISTING CLOSE;
/*ODS HTML BODY=mail;*/

data _null_;
file mail;
put 'HELLO';
put 'ATTACH FILE';
put ' ';
put ' ';
put ' ';
put 'REGARDS';
run;

Re: ODS EXCEL---Excel sheet layout-right to left

Kathryn_SAS — Tue, 10 Jun 2025 11:51:21 GMT

Here is a similar post to what you are asking:

https://communities.sas.com/t5/SAS-Programming/Ods-excel-right-to-left/td-p/877128

topic Re: ODS EXCEL---Excel sheet layout-right to left in SAS Programming

ODS EXCEL---Excel sheet layout-right to left

Re: ODS EXCEL---Excel sheet layout-right to left