php excel复制sheet宏,使用PHPExcel复制样式的解决方法

一个workround for you可能是使用样式xf索引：

$xfIndex = $activeSheet->getCell('A1')->getXfIndex();

然后为该范围内所有单元格的xfIndex设置该值

for ($col = 'D'; $col != 'E'; ++$col) {

for ($row = 1; $row <= 100; ++$row) {

$activeSheet->getCell($col . $row)->setXfIndex($xfIndex);

}

}

编辑

或者,将修复应用于Classes / PHPExcel / Worksheet.php中的duplicateStyle()方法

目前阅读第1479至1486行：

if ($this->_parent->cellXfExists($pCellStyle)) {

// there is already this cell Xf in our collection

$xfIndex = $pCellStyle->getIndex();

} else {

// we don't have such a cell Xf, need to add

$workbook->addCellXf($pCellStyle);

$xfIndex = $pCellStyle->getIndex();

}

改成：

if ($existingStyle = $this->_parent->getCellXfByHashCode($pCellStyle->getHashCode())) {

// there is already such cell Xf in our collection

$xfIndex = $existingStyle->getIndex();

} else {

// we don't have such a cell Xf, need to add

$workbook->addCellXf($pCellStyle);

$xfIndex = $pCellStyle->getIndex();

}

类似地在Classes / PHPExcel / Style.php中的applyFromArray()方法中

第425至432行目前已阅读：

if ($workbook->cellXfExists($newStyle)) {

// there is already such cell Xf in our collection

$newXfIndexes[$oldXfIndex] = $existingStyle->getIndex();

} else {

// we don't have such a cell Xf, need to add

$workbook->addCellXf($newStyle);

$newXfIndexes[$oldXfIndex] = $newStyle->getIndex();

}

改成：

if ($existingStyle = $workbook->getCellXfByHashCode($newStyle->getHashCode())) {

// there is already such cell Xf in our collection

$newXfIndexes[$oldXfIndex] = $existingStyle->getIndex();

} else {

// we don't have such a cell Xf, need to add

$workbook->addCellXf($newStyle);

$newXfIndexes[$oldXfIndex] = $newStyle->getIndex();

}

编辑#2

Fix现已被推送到github上的develop分支.根据使用的样式数量,它确实会有轻微的性能影响……我会尝试明天晚上获得更快的版本