public function PHPExcel_Worksheet::setAutoFilterByColumnAndRow in Loft Data Grids 6.2

Same name and namespace in other branches

1. 7.2 vendor/phpoffice/phpexcel/Classes/PHPExcel/Worksheet.php \PHPExcel_Worksheet::setAutoFilterByColumnAndRow()

Set Autofilter Range by using numeric cell coordinates

Parameters

integer $pColumn1 Numeric column coordinate of the first cell: @param integer $pRow1 Numeric row coordinate of the first cell @param integer $pColumn2 Numeric column coordinate of the second cell @param integer $pRow2 Numeric row coordinate of the second cell @throws PHPExcel_Exception @return PHPExcel_Worksheet

File

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

Class

PHPExcel_Worksheet

PHPExcel_Worksheet

Code

public function setAutoFilterByColumnAndRow($pColumn1 = 0, $pRow1 = 1, $pColumn2 = 0, $pRow2 = 1) {
  return $this
    ->setAutoFilter(PHPExcel_Cell::stringFromColumnIndex($pColumn1) . $pRow1 . ':' . PHPExcel_Cell::stringFromColumnIndex($pColumn2) . $pRow2);
}