liangming1
V2EX  ›  问与答

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

  •  
  •   liangming1 · Dec 21, 2018 · 2499 views
    This topic created in 2702 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   ·   942 Online   Highest 6679   ·     Select Language
    创意工作者们的社区
    World is powered by solitude
    VERSION: 3.9.8.5 · 27ms · UTC 19:38 · PVG 03:38 · LAX 12:38 · JFK 15:38
    ♥ Do have faith in what you're doing.