PHPExcel 使用 $newExcel->addExternalSheet($sheet); 复制 sheet 到新的表格里面，新的表格生成的背景颜色 有差距
liangming1 · Dec 21, 2018 · 2469 viewsThis topic created in 2693 days ago, the information mentioned may be changed or developed.
代码如下：
$k = 0;
foreach ($objPHPExcel->getSheetNames() as $sheetName){
$sheet = clone $objPHPExcel->getSheetByName($sheetName);
$sheet->setTitle('Sheet'.$k);
$newExcel->addExternalSheet($sheet);
unset($sheet);
$k ++;
}
$k = 0;
foreach ($objPHPExcel->getSheetNames() as $sheetName){
$sheet = clone $objPHPExcel->getSheetByName($sheetName);
$sheet->setTitle('Sheet'.$k);
$newExcel->addExternalSheet($sheet);
unset($sheet);
$k ++;
}
No Comments Yet
Select Language