$_workSheet
$_workSheet : \PHPExcel_Worksheet
Autofilter Worksheet
PHPExcel_Worksheet_AutoFilter
$_workSheet : \PHPExcel_Worksheet
Autofilter Worksheet
__construct(string $pRange = '', \PHPExcel_Worksheet $pSheet = NULL)
Create a new PHPExcel_Worksheet_AutoFilter
| string | $pRange | Cell range (i.e. A1:E10) |
| \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 |
setRange(string $pRange = '') : \PHPExcel_Worksheet_AutoFilter
Set AutoFilter Range
| string | $pRange | Cell range (i.e. A1:E10) |
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) |
setColumn(\PHPExcel_Worksheet_AutoFilter_Column|string $pColumn) : \PHPExcel_Worksheet_AutoFilter
Set AutoFilter
| \PHPExcel_Worksheet_AutoFilter_Column|string | $pColumn | A simple string containing a Column ID like 'A' is permitted |
clearColumn(string $pColumn) : \PHPExcel_Worksheet_AutoFilter
Clear a specified AutoFilter Column
| string | $pColumn | Column name (e.g. A) |
shiftColumn(string $fromColumn = NULL, string $toColumn = NULL) : \PHPExcel_Worksheet_AutoFilter
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) |
| string | $toColumn | Column name (e.g. B) |
showHideRows() : \PHPExcel_Worksheet_AutoFilter
Apply the AutoFilter rules to the AutoFilter Range