How to set the text (wrap text) in two or three lines in column for excel using OLE SAP ABAP ?

[former_member396057]

Hi All,

I am downloading the data into excel using OLE SAP ABAP report program.

I have 5 columns.There is one column which has long name.I want to wrap the text(in two or three lines text ) in this particular column for excel using OLE SAP ABAP.

Attached screenshots for reference.current-format.pngrequired-format.png

Regards,

Shabbir

[raymond_giuseppi]

To insert line feed in the cell, wrap the field value between double quotes to prevent multiple cells splitting and insert some cl_abap_char_utilities=>cr_lf between lines.

[former_member622454]

Hi Shabbir,

Could you meet the requirement? How could you solve it. I have similar requirement in my project too but unable to find solution.