liangming1
V2EX  ›  问与答

PHPExcel 使用 $newExcel->addExternalSheet($sheet); 复制 sheet 到新的表格里面,新的表格生成的背景颜色 有差距

  •  
  •   liangming1 · Dec 21, 2018 · 2595 views
    This topic created in 2750 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 ++;
    }
    No Comments Yet
    About   ·   Help   ·   Advertise   ·   Blog   ·   API   ·   FAQ   ·   Solana   ·   3735 Online   Highest 6679   ·     Select Language
    创意工作者们的社区
    World is powered by solitude
    VERSION: 3.9.8.5 · 51ms · UTC 10:29 · PVG 18:29 · LAX 03:29 · JFK 06:29
    ♥ Do have faith in what you're doing.