$workSheet
$workSheet : \PHPExcel_Worksheet
Autofilter Worksheet
PHPExcel_Worksheet_AutoFilter
Copyright (c) 2006 - 2015 PHPExcel
This library is free software; you can redistribute it and/or modify it under the terms of the GNU Lesser General Public License as published by the Free Software Foundation; either version 2.1 of the License, or (at your option) any later version.
This library is distributed in the hope that it will be useful, but WITHOUT ANY WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU Lesser General Public License for more details.
You should have received a copy of the GNU Lesser General Public License along with this library; if not, write to the Free Software Foundation, Inc., 51 Franklin Street, Fifth Floor, Boston, MA 02110-1301 USA
$workSheet : \PHPExcel_Worksheet
Autofilter Worksheet
__construct( $pRange = '', \PHPExcel_Worksheet $pSheet = null)
Create a new PHPExcel_Worksheet_AutoFilter
@param string $pRange Cell range (i.e. A1:E10)
| $pRange | ||
| \PHPExcel_Worksheet | $pSheet |
getParent() : \PHPExcel_Worksheet
Get AutoFilter Parent Worksheet
setParent(\PHPExcel_Worksheet $pSheet = null) : \PHPExcel_Worksheet_AutoFilter
Set AutoFilter Parent Worksheet
| \PHPExcel_Worksheet | $pSheet |
getColumn(string $pColumn) : \PHPExcel_Worksheet_AutoFilter_Column
Get a specified AutoFilter Column
| string | $pColumn | Column name (e.g. A) |
getColumnByOffset(integer $pColumnOffset) : \PHPExcel_Worksheet_AutoFilter_Column
Get a specified AutoFilter Column by it's offset
| integer | $pColumnOffset | Column offset within range (starting from 0) |
clearColumn(string $pColumn) : \PHPExcel_Worksheet_AutoFilter
Clear a specified AutoFilter Column
| string | $pColumn | Column name (e.g. A) |
shiftColumn(string $fromColumn = null, $toColumn = null)
Shift an AutoFilter Column Rule to a different column
Note: This method bypasses validation of the destination column to ensure it is within this AutoFilter range. Nor does it verify whether any column rule already exists at $toColumn, but will simply overrideany existing value. Use with caution.
| string | $fromColumn | Column name (e.g. A) @param string $toColumn Column name (e.g. B) @return PHPExcel_Worksheet_AutoFilter |
| $toColumn |
showHideRows() : \PHPExcel_Worksheet_AutoFilter
Apply the AutoFilter rules to the AutoFilter Range
@throws PHPExcel_Exception