Merge Cell values with PHPExcel - PHP

There is a specific method to do this:

$objPHPExcel->getActiveSheet()->mergeCells('A1:C1');

You can also use:

$objPHPExcel->setActiveSheetIndex(0)->mergeCells('A1:C1');

That should do the trick.

php phpexcel phpspreadsheet

Try this

$objPHPExcel->getActiveSheet()->mergeCells('A1:C1');

php phpexcel phpspreadsheet

$this->excel->setActiveSheetIndex(0)->mergeCells("A".($p).":B".($p));for dynamic merging of cells

CodeHunter