Dynamic Cell Merging in phpspreadsheet

Question

My question is about generating an Excel sheet in codeigniter. The excel sheet sub-headings are not fixed, they are as per data, that's why i am not able to merge cells. Is there any solution for that? Ex:-Here sub-headings are not fix.

Answer 1

$spreadsheet->getActiveSheet()->mergeCells("from:to");

exemple: $spreadsheet->getActiveSheet()->mergeCells("A1:F1");

Answer 2

$spreadsheet->getActiveSheet()->mergeCells("$range1:$range2");