I've been trying to make a new line in exporting data to excel file with this code
if ($campaign['type'] == 'blended') {
$objWorkSheet->setCellValueByColumnAndRow($col++, $row, "$launch_date,
email: {$email_launch_date},
tm: {$tm_launch_date}");
$objPHPExcel->getActiveSheet()->getAlignment()->setWrapText(true);
But this gives me
Type: Error Message: Call to undefined method PHPExcel_Worksheet::getAlignment()
I also try the suggestion here but it doesn't work for me,
what is the right thing to do?
You should be applying styles to individual cells or ranges of cells, not to worksheets (which don't have a style)
if ($campaign['type'] == 'blended') {
$objWorkSheet->setCellValueByColumnAndRow($col, $row, "$launch_date,
email: {$email_launch_date},
tm: {$tm_launch_date}");
$objWorkSheet->getStyle(PHPExcel_Cell::stringFromColumnIndex($col) . $row)
->getAlignment()
->setWrapText(true);
$col++;
}