How to pass a CR+LF to Excel

[Administrator]

Hi,

I have a string that contains CR+LF. What I have to do that the exported value is equivalent to ALT+ENTER in Excel?

Regards,
Thomas

[Administrator]

Hi Thomas,

Thank you for your interest in Syncfusion Essential ExcelRW.

The equivalent of ALT+ENTER would be \n and setting the wraptext property to be true;

Example,

sheet.Range[1,1].Text = "LineOne\nLineTwo";
sheet.Range[1,1].CellStyle.WrapText = true;

Hope that helps. Thanks.

Best regards,

Stephen.

>Hi,
>
>I have a string that contains CR+LF. What I have to do that the exported value is equivalent to ALT+ENTER in Excel?
>
>Regards,
>Thomas

[Administrator]

Thanks Stephen, that''s exactly what I''m looking for!

Regards,
Thomas