i want to merge 3 cells become one,so i make the code :
while ($data3 = db_fetch_array($r1sSql)){
$row3 = $cdrow + $cr;
$spreadsheet->getSheetByName($sheetsjk)->insertNewRowBefore($row3, 1);
$spreadsheet->getSheetByName($sheetsjk)->mergeCells('B' . $row3 : 'D' . $row3);
$spreadsheet->getSheetByName($sheetsjk)
->setCellValue('A' . $row3, $cr + 1)
->setCellValue('B' . $row3, $data3['nama'])
->setCellValue('E' . $row3, $data3['brand'])
;
$cr= $cr+1;
}
$spreadsheet->getSheetByName($sheetsjk)->removeRow($cdrow - 1, 1);
but then i got this message:
Parse error: syntax error, unexpected token ":", expecting ")" in C:\xampp\htdocs\a\ICM\aas.php on line 86.
and line 86 is $spreadsheet->getSheetByName($sheetsjk)->mergeCells('B' . $row3 : 'D' . $row3);
any advice please?