public function PHPExcel_Worksheet_PageSetup::addPrintAreaByColumnAndRow in Loft Data Grids 7.2

Same name and namespace in other branches

1. 6.2 vendor/phpoffice/phpexcel/Classes/PHPExcel/Worksheet/PageSetup.php \PHPExcel_Worksheet_PageSetup::addPrintAreaByColumnAndRow()

* Add a new print area to the list of print areas * *

Parameters

int $column1 Start Column for the print area: * @param int $row1 Start Row for the print area * @param int $column2 End Column for the print area * @param int $row2 End Row for the print area * @param int $index Identifier for a specific print area range allowing several ranges to be set * A positive index will insert after that indexed entry in the print areas list, while a * negative index will insert before the indexed entry. * Specifying an index value of 0, will always append the new print range at the end of the * list. * Print areas are numbered from 1 * @return PHPExcel_Worksheet_PageSetup * @throws PHPExcel_Exception

File

vendor/phpoffice/phpexcel/Classes/PHPExcel/Worksheet/PageSetup.php, line 751

Class

PHPExcel_Worksheet_PageSetup

PHPExcel_Worksheet_PageSetup

Code

public function addPrintAreaByColumnAndRow($column1, $row1, $column2, $row2, $index = -1) {
  return $this
    ->setPrintArea(PHPExcel_Cell::stringFromColumnIndex($column1) . $row1 . ':' . PHPExcel_Cell::stringFromColumnIndex($column2) . $row2, $index, self::SETPRINTRANGE_INSERT);
}