2. General Tips and Tricks
  3. [SOLVED] phprunner and phpspreadsheet
This topic is locked
[SOLVED]

phprunner and phpspreadsheet

 		5/12/2024 2:36:29 PM
General Tips and Tricks
R
 rkn2003 author

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?
M
 		MikeT 5/12/2024

you probably need to quote the : and concatenate it with the rest.
The resulting string needs to look like 'B3:D3' (just as an example)
R
 		rkn2003 author 5/12/2024

i just try many way, but still not working
R
 		rkn2003 author 5/12/2024

hi...i just try
$cro ='B'.$row3;
$cre ='D'.$row3;
$spreadsheet->getSheetByName($sheetsjk)->mergeCells("{$cro}:{$cre}");

and it worked