在PHPExcel我合并三个单元格，并有foreach循环。(In PHPExcel i merger three cell and having foreach loop. Result next

在PHPExcel我合并三个单元格，并有foreach循环。(In PHPExcel i merger three cell and having foreach loop. Result next value not printed after merge)

$ periodOne = array（array（'SNO'，'Appraisal'，'TOT'，'AVG'，'CLS TOT'，'CLS AVG'，'DIFF'））;

$rowID = 7; foreach($periodOne as $rowArray) { $columnID = 'A'; foreach($rowArray as $columnValue) { $this->setActiveSheetIndex(0)->mergeCells('B7:D7'); $this->getActiveSheet()->setCellValue($columnID.$rowID,$columnValue); $columnID++; } $rowID++; }

$periodOne=array(array('SNO','Appraisal','TOT','AVG','CLS TOT','CLS AVG','DIFF'));

$rowID = 7; foreach($periodOne as $rowArray) { $columnID = 'A'; foreach($rowArray as $columnValue) { $this->setActiveSheetIndex(0)->mergeCells('B7:D7'); $this->getActiveSheet()->setCellValue($columnID.$rowID,$columnValue); $columnID++; } $rowID++; }

最满意答案

$periodOne=array(array('SNO','Appraisal','TOT','AVG','CLS TOT','CLS AVG','DIFF')); $rowID = 7; foreach($periodOne as $rowArray) { $columnID = 'A'; foreach($rowArray as $columnValue) { if($columnID.$rowID == 'C7') { $columnID = 'E'; $this->getActiveSheet()->setCellValue($columnID.$rowID,$columnValue); } else { $this->getActiveSheet()->setCellValue($columnID.$rowID,$columnValue); } $columnID++; } $rowID++; } $periodOne=array(array('SNO','Appraisal','TOT','AVG','CLS TOT','CLS AVG','DIFF')); $rowID = 7; foreach($periodOne as $rowArray) { $columnID = 'A'; foreach($rowArray as $columnValue) { if($columnID.$rowID == 'C7') { $columnID = 'E'; $this->getActiveSheet()->setCellValue($columnID.$rowID,$columnValue); } else { $this->getActiveSheet()->setCellValue($columnID.$rowID,$columnValue); } $columnID++; } $rowID++; }