我使用库 PHPExcel 1.7.9来处理Excel@L_777_1@.首先,我创建@L_360_2@模板,风格和抛光它.然后,为避免样式硬编码,使用上面提到的库我打开该模板,更改一些值并将其另存为新的.xlsx文件.

首先,我们从单元格中获取该样式.

$this->styles = array() ;
$this->styles['category'] = $sheet->getStyle("A4");
$this->styles['subcategory'] = $sheet->getStyle("A5");

这是递归函数,它显示类别和子类别.

PRivate function displayCategories($categories,&$row,$level = 0){
    $sheet = $this->content ;

    foreach($categories as $category){
        if ($category->hasChildren() || $category->hasITems()){ //Check if the row has changed.
            $sheet->getRowDimension($row)->setRowHeight(20);
            $sheet->;mergeCells(Cell::NUMBER . $row . ":" . Cell::total . $row) ;

            $name = ($level == 0) ? strtoupPEr($category->name) : str_repeat(" ",$level*6) ."- {$category->name}" ;
            $sheet->setCellValue(Cell::NUMBER . $row,$name) ;
            $sheet->duplicatestyle((($level == 0) ?  $this->styles['category'] : $this->styles['subcategory']),Cell::NUMBER . $row);

            $row++ ;
            if ($category->hasChildren()){
                $this->displayCategories($category->children,$row,$level+1);
            }
        }
    }   
}

问题

如果使用$sheet-> duplicateStyle(),由于无限递归,将无法保存文档.

问题出在下一段代码中,在PHPExcel_Style_Fill类中,一个对象反复引用自己.

public function getHashCode() { //class PHPExcel_Style_Fill
    if ($this->_isSupervisor) { 
        var_dump($this === $this->getSharedcomponent()); //Always true 200 times
        return $this->getSharedComponent()->getHashCode();
    }
    return md5(
          $this->getFillType()
        . $this->getRotation()
        . $this->getStartColor()->getHashCode()
        . $this->getEndColor()->getHashCode()
        . __CLASS__
    );
}

有没有解决方法可以解决这个问题？我也接受任何有关如何将一个完整的单元格应用于另一个单元格的想法.

解：

正如@MarkBaker在评论中所说,GitHub上的分支开发确实包含对bug的修复.

$PHPe = new PHPExcel();
$sheet = $PHPe->createSheet();

$sheet->setCellValue('A1','hi there') ;
$sheet->setCellValue('A2','hi again') ;

$sheet->duplicateStyle($sheet->getStyle('A1'),'A2');

$writer = new PHPExcel_Writer_Excel2007($PHPe);
$writer->save('./test.xlsx');

$sheet->duplicateStyle($sheet->getStyle('A1'),'A1');

$sheet->duplicateStyle((($level == 0) ?  $this->styles['category'] : $this->styles['subcategory']),Cell::NUMBER . $row);

$style = ($level == 0) ?  $this->styles['category'] : $this->styles['subcategory'];
$targetCoords = Cell::NUMBER . $row;
if($style->getActiveCell() != $targetCoords) {
    $sheet->duplicateStyle($style,$targetCoords);
}