liangming1
V2EX  ›  问与答

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

  •  
  •   liangming1 · Dec 21, 2018 · 2547 views
    This topic created in 2733 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   ·   1153 Online   Highest 6679   ·     Select Language
    创意工作者们的社区
    World is powered by solitude
    VERSION: 3.9.8.5 · 32ms · UTC 18:08 · PVG 02:08 · LAX 11:08 · JFK 14:08
    ♥ Do have faith in what you're doing.