Ovidiu Buligan Ovidiu Buligan - 1 year ago 114
PHP Question

Adding new line in excel cell generated via html

I'm trying to generate an excel file using html in php and responding with an excel Content-type. Everything works fine except new lines within a cell . They are not preserved.
I've tried &#13 ;&#10 ; \r\n ,chr(13).chr(10) and it didn't work.
I'm trying to get the same result from alt + enter from microsoft Excel .

I am generating in a cell content like:

(Event) ...

these have to be in a single cell and also converting the link text to hyperlinks would be great :).

Answer Source

I've found a solution here: http://www.bennadel.com/blog/1095-maintaining-line-breaks-in-an-html-excel-file.htm

The solution I found is to add into a stylesheet:

br {mso-data-placement:same-cell;}
Recommended from our users: Dynamic Network Monitoring from WhatsUp Gold from IPSwitch. Free Download