Merge cells by numbers

[egrittini-solinfo]

Hi, is it possibile to merge cells by using something like that?

$spreadsheet->getActiveSheet()->mergeCells([3,1].':'.[6,1]);

[noombkk]

You can use
$spreadsheet->getActiveSheet()->mergeCells(chr(68) . '1:' . chr(71) . 1);
chr(65) = A, chr(66) = B . . . .
Wish you success

[oleibman]

In general, you can always convert [$column, $row] to a form usable by mergeCells using:

\PhpOffice\PhpSpreadsheet\Cell\CellAddress::fromColumnRowArray([$column, $row])

However, even more simply in your case, mergeCells will let you specify:

$spreadsheet->getActiveSheet()->mergeCells([3,1,6,1]);