Excel line break within same cell?

Asked Mar 19 '15 at 22:55

Active Mar 19 '15 at 22:55

Viewed 1,327 times

Can someone tell me how to simply make a line break within the same cell when exporting a .xls file using PHP? I've tried with \n, \t, \r, but none of them seems to work.

My code is short and simple:

ob_end_clean();
$filename ="test_doc.xls";
header('Content-type: application/ms-excel');
header('Content-Disposition: attachment; filename='.$filename);
echo "I\nWANT\nTHIS\nTO\nBE\nWITHIN\nTHE\nSAME\nCELL";
exit;

asked Mar 19 '15 at 22:55

user2994294

have you tried \r\n ? – MightyPork Mar 19 '15 at 22:57
@MightyPork Just tried it, doesn't seem to work either. – user2994294 Mar 19 '15 at 22:59
If you open the output and select the cell, do you get new lines in the formula bar? http://stackoverflow.com/a/1177801/212869 – NickSlash Mar 19 '15 at 23:15
Depends if you actually want to write a real BIFF-format Excel file or simply a csv file – Mark Baker Mar 19 '15 at 23:25
`echo "\"I\nWANT\nTHIS\nTO\nBE\nWITHIN\nTHE\nSAME\nCELL\"";` – Axel Richter Mar 20 '15 at 06:18
@AxelRichter worked, then comes the other question: how do i get out from the cell? – user2994294 Mar 23 '15 at 20:58
Not sure if I understand your "other" question right, but maybe `echo "\"I\nWANT\nTHIS\nTO\nBE\nWITHIN\nTHE\nSAME\nCELL\"\t\"Next Cell\"\t1234";`? – Axel Richter Mar 24 '15 at 06:22

Excel line break within same cell?

0 Answers0