public function PHPExcel_Worksheet::insertNewRowBefore in Loft Data Grids 7.2

Same name and namespace in other branches

1. 6.2 vendor/phpoffice/phpexcel/Classes/PHPExcel/Worksheet.php \PHPExcel_Worksheet::insertNewRowBefore()

Insert a new row, updating all possible related data

Parameters

int $pBefore Insert before this one:

int $pNumRows Number of rows to insert:

Return value

PHPExcel_Worksheet

Throws

PHPExcel_Exception

File

vendor/phpoffice/phpexcel/Classes/PHPExcel/Worksheet.php, line 2013

Class

PHPExcel_Worksheet

PHPExcel_Worksheet

Code

public function insertNewRowBefore($pBefore = 1, $pNumRows = 1) {
  if ($pBefore >= 1) {
    $objReferenceHelper = PHPExcel_ReferenceHelper::getInstance();
    $objReferenceHelper
      ->insertNewBefore('A' . $pBefore, 0, $pNumRows, $this);
  }
  else {
    throw new PHPExcel_Exception("Rows can only be inserted before at least row 1.");
  }
  return $this;
}