How to merge and split cells in PHPExcel

How does PHPExcel merge and split cells? This article mainly introduces the method of merging and splitting cells in PHPExcel, involving the usage skills of setCellValue and mergeCells methods in PHPExcel. Friends in need can refer to it. I hope to be helpful.

$objPHPExcel;
$filepath="c:\temp.xlsx";
try {
  $objReader = PHPExcel_IOFactory::createReader('Excel2007');
  $objPHPExcel = $objReader->load($filepath);
} catch (Exception $e) {
  die();
}
$column_index = "A";
//清空要合并的首行单元格值，用于填充合并后的单元格值
$objPHPExcel->getActiveSheet()->setCellValue($column_index.''.$beginRow,'');
//合并单元格,值为''
$objPHPExcel->getActiveSheet()->mergeCells($column_index.''.$beginRow.":".$column_index.''.$endRow);
//拆分单元格,将清空合并前单元格的值并还原合并前单元格的样式
$objPHPExcel->getActiveSheet()->unmergeCells($column_index.''.$beginRow.":".$column_index.''.$endRow);

Related recommendations:

Example sharing of solving PHPExcel memory leaks

PHPExcel introduces the method of freezing and locking headers

How does phpexcel import excel to process big data code examples

The above is the detailed content of How to merge and split cells in PHPExcel. For more information, please follow other related articles on the PHP Chinese website!