line breaks within a cell

[rajeev13]

Thanks for your effort and support.
how can we add line breaks within cell itself.

[smrrrazu]

I have same question.

[rajeev13]

Hi Travis Clarke,

The reference #70 is about new line creating new row,but i am trying the line break in a particular cell itself .

suggested method didn't helped me.

Thank for reply.

[clarketm]

@rajeev13

You are correct – my mistake. I deleted my comment as soon as I realized it was invalid. XLSX seems to be the exception to the fix delineated in #70 .

There are some quirks with Excel related to consistency and which escape characters are interpreted as linefeed and carriage return across platforms (in open xml format). I may be able to achieve this with a cell-style (if supported), but in the meantime, a workaround is to use standard linefeeds in the HTML (
, <br>, or literal return) and enable wrap text in Excel: