ods excel file - break in the Excel cell

[Tecla1]

Good afternoon,

I wrote a piece of data that allows me to export to Excel with formatting. However, in the output the text wraps as if the "ALT+ENTER" function in Excel was active. I tried to solve it with "wrap" without success.

Can you help me?

Thank you

ods excel file="prova.xlsx" options
(
   sheet_name="Dati"
    embedded_titles='yes'
    autofilter='yes'
    frozen_headers='yes'
    tab_color='blue'
);

proc report  data=new.prova nowd
    style(report)=[frame=void rules=none width=50%]; 
    define PRESENZA_SOSPESI_SI_NO / style(header)=[background=#009597 foreground=white font_weight=bold]; 
	define INTERVENTI /style(header)=[background=#009597 foreground=white font_weight=bold];
run;

ods excel close;

[Kathryn_SAS]

Try adding the FLOW='TABLES' suboption as shown below and described in this SAS Note:

KB0039821 

ods excel file="prova.xlsx" options
(
   sheet_name="Dati"
    embedded_titles='yes'
    autofilter='yes'
    frozen_headers='yes'
    tab_color='blue'
flow='tables');

[Ksharp · Accepted solution]

proc report  data=new.prova nowd
    style(report)=[frame=void rules=none width=50%]; 
    define PRESENZA_SOSPESI_SI_NO / style(header)=[background=#009597 foreground=white font_weight=bold]; 
	define INTERVENTI /style(column)=[tagattrs="wrap:no"];
run;

[Tecla1]

Many Tnks Ksharp! IT's so good !!! have a nice day!!