how to make a line break in a cell ?

[Alban Faverot]

in the header row , i''d like to make a line break . example :

My Quantity
|
|
v
My
Quantity

how can i do ?

Thxs

[Administrator]

Hi,

Please try using \n inserted at the place where you need the line break

mySheet.Range["A1"].Text = "Hello\nWorld";
mySheet.Range["A1"].CellStyle.WrapText= true;

Thanks,

Stephen.

>in the header row , i''d like to make a line break . example :
>
>My Quantity
>|
>|
>v
>My
>Quantity
>
>how can i do ?
>
>Thxs