proc report : wrap text inside the excel celles

[Nasser_DRMCP]

ODS LISTING CLOSE;
ODS EXCEL FILE="$GRPFPU/REQUETES_PROD/TEST_NASSER2.xlsx" STYLE=HTMLBlue;
ods excel options(flow='tables'
                  row_heights='0,14,0,0,0,0,0'
                  sheet_name='Using flow and row_height');
  
proc report data=sashelp.baseball(obs=10)
STYLE(column)=[cellwidth=1cm ];
  column name team league division natbat nhits nruns nrbi;
  define _all_/style={tagattr='wrap:no' verticalalign=T just=l} ;

run;

ods excel close; 

hello

Hello

this is the code I executed and this is the result.

the name "Allanson, Andy" has no return carriage inside the formula bar (as attended)

But by cliking inside the cell A2, a RC appears; maybe because the "wrap text button" is activate.

by desactivate it, the RC disapears, this is what I want. how to deal with that "issu" ?

thanks a lot in advance;

regards,

Nasser

[ChrisNZ]

Have you seen these pages?

https://communities.sas.com/t5/ODS-and-Base-Reporting/ODS-Excel-Issues/td-p/593710

https://communities.sas.com/t5/ODS-and-Base-Reporting/ODS-Excel-PROC-ODSTEXT-and-tagattr-wraptext/td...

[Nasser_DRMCP]

hello

many thanks for your help.

I am sorry but I do not find the solution. certainly,  i do not understand your suggestions.

this "basic" code below works well. I mean there is no RC

ODS LISTING CLOSE;
ODS EXCEL FILE="$GRPFPU/REQUETES_PROD/TEST_NASSER2.xlsx" STYLE=HTMLBlue;
ods excel options(sheet_name='sheet'
			 	Absolute_Column_Width="10" 	);
  
proc report data=sashelp.baseball(obs=10) ;

  column name team league division natbat nhits  ;
 
 run;

ods excel close; 

and then, by adding the column "nruns", a RC appears inside row 6 column A. I wonder why.

thanks for your time.

regards

[Nasser_DRMCP]

hello,

I copy/past the excel result in ultraedit and then I notice that a RC appears (but also quotes)

manu thanks for your hep