how to make New lines in a cell using phpexcel
$objPHPExcel->getActiveSheet()->setCellValue('H5', "Hello\nWorld");
$objPHPExcel->getActiveSheet()->getStyle('H5')->getAlignment()->setWrapText(true);
Works for me...
You should always use double quotes when you add escape sequences in a PHP string.
Improved answer based on Ravin and others
$objPHPExcel
->getActiveSheet()
->setCellValue('H5', "Hello".PHP_EOL." World");
$objPHPExcel
->getActiveSheet()
->getStyle('H5')
->getAlignment()
->setWrapText(true);
you should use 'r' to break into new line into excel with php
and use double quotes when you add escape sequences in a PHP string.
$objPHPExcel->getActiveSheet()->setCellValue('H5', "Hello\r World");
$objPHPExcel->getActiveSheet()->getStyle('H5')->getAlignment()->setWrapText(true);