Menu
Hi I have thw following code:
header('Content-type: application/vnd.ms-excel');
header("Content-Disposition: attachment; filename=archivo.xls");
header("Pragma: no-cache");
header("Expires: 0");
echo "
<html>
<head>
<meta charset="utf-8">
<meta http-equiv="expires" content="0">
</head>
<body>
<table width="100%" border="1" align="center" cellpadding="3" cellspacing="0">
<tr>
<td>Line 1<br>Line 2</td>
</tr>
</table>
</body>
</html>";
I have tried:
<td>Line 1\r\nLine 2</td>
<td>Line 1".chr(10) . chr(13)."Line 2</td>
But nothing seems to work, I need to do a line break in a cell, any suggestions are welcomed. I'm using excel 2010.
I already look at this question: line break within data for Excel 2003 and it didnt work.
It doesnt show error, when I apply <br> it creates a new row, when I use \r\n, \n, or chr(10) . chr(13), it creates a space.
Thanks!!
416
After searching a lot found this site: http://www.bennadel.com/blog/1095-maintaining-line-breaks-in-an-html-excel-file.htm
And this tag solves the issue <br style="mso-data-placement:same-cell;" />
Thanks for all your comments!!
93
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
