Geek Answers Handbook

PHPExcel Fast Repeating String

I have a row with different styles for each cell. I need to duplicate it (copy text, style, size).

I used the following function:

  function copyRowFull(&$ws_from, &$ws_to, $row_from, $row_to) {
    $ws_to->getRowDimension($row_to)->setRowHeight($ws_from->getRowDimension($row_from)->getRowHeight());
    $lastColumn = $ws_from->getHighestColumn();
    $rangeFrom = 'A'.$row_from.':'.$lastColumn.$row_from;
    // copy text
    $ws_to->fromArray($ws_from->rangeToArray($rangeFrom), null, 'A'.$row_to);
    // copy style
    ++$lastColumn;
    for ($c = 'A'; $c != $lastColumn; ++$c) {
      $ws_to->duplicateStyle($ws_from->getStyle($c.$row_from), $c.$row_to);
    }
  }

However, it is very slow due to the loop, but I need it quickly because many lines will be copied.

I also tried this to copy the style:

$rangeTo = 'A'.$row_to.':'.$lastColumn.$row_to;
$ws_to->getStyle($rangeTo)->applyFromArray($ws_from->getStyle($rangeFrom));

But this will not work - it throws the error "Invalid array of styles passed."

Is there a faster method?

+4
source share
2 answers

PHPExcel- . , , . , , - .

function copyRowFull(&$ws_from, &$ws_to, $row_from, $row_to) {
  $ws_to->getRowDimension($row_to)->setRowHeight($ws_from->getRowDimension($row_from)->getRowHeight());
  $lastColumn = $ws_from->getHighestColumn();
  ++$lastColumn;
  for ($c = 'A'; $c != $lastColumn; ++$c) {
    $cell_from = $ws_from->getCell($c.$row_from);
    $cell_to = $ws_to->getCell($c.$row_to);
    $cell_to->setXfIndex($cell_from->getXfIndex()); // black magic here
    $cell_to->setValue($cell_from->getValue());
  }
}
+7

, PHP 5.3 , Somnium Ravean PHP 5.3:

    /**
 * Copies entire row with formatting and merging
 * @param $ws_from
 * @param $ws_to
 * @param $row_from
 * @param $row_to
 * @throws PHPExcel_Exception
 */
public function copyRowFull(&$ws_from, &$ws_to, $row_from, $row_to)
{
    $ws_to->getRowDimension($row_to)->setRowHeight($ws_from->getRowDimension($row_from)->getRowHeight());
    $lastColumn = $ws_from->getHighestColumn();
    ++$lastColumn;
    for ($c = 'A'; $c != $lastColumn; ++$c) {
        $cell_from = $ws_from->getCell($c . $row_from);
        if ($cell_from->isMergeRangeValueCell()) {
            $pCoordinateString = PHPExcel_Cell::splitRange($cell_from->getMergeRange());
            $coordinateFromString = PHPExcel_Cell::coordinateFromString($pCoordinateString[0][1]);
            $col = $coordinateFromString[0];
            $ws_to->mergeCells($c . $row_to . ':' . $col . $row_to);
            //$cell->getMergeRange()
        }
        $cell_to = $ws_to->getCell($c . $row_to);
        $cell_to->setXfIndex($cell_from->getXfIndex()); // black magic here
        $cell_to->setValue($cell_from->getValue());
    }
}
0

More articles:


All Articles