AUTOFILTER_FILTERTYPE_FILTER
AUTOFILTER_FILTERTYPE_FILTER = 'filters'
$parent : \PhpOffice\PhpSpreadsheet\Worksheet\AutoFilter
Autofilter.
__construct(string $pColumn, \PhpOffice\PhpSpreadsheet\Worksheet\AutoFilter $pParent = null)
Create a new Column.
string | $pColumn | Column (e.g. A) |
\PhpOffice\PhpSpreadsheet\Worksheet\AutoFilter | $pParent | Autofilter for this column |
setColumnIndex(string $pColumn) : \PhpOffice\PhpSpreadsheet\Worksheet\AutoFilter\Column
Set AutoFilter Column Index.
string | $pColumn | Column (e.g. A) |
getParent() : \PhpOffice\PhpSpreadsheet\Worksheet\AutoFilter
Get this Column's AutoFilter Parent.
setParent(\PhpOffice\PhpSpreadsheet\Worksheet\AutoFilter $pParent = null) : \PhpOffice\PhpSpreadsheet\Worksheet\AutoFilter\Column
Set this Column's AutoFilter Parent.
\PhpOffice\PhpSpreadsheet\Worksheet\AutoFilter | $pParent |
setFilterType(string $pFilterType) : \PhpOffice\PhpSpreadsheet\Worksheet\AutoFilter\Column
Set AutoFilter Type.
string | $pFilterType |
setJoin(string $pJoin) : \PhpOffice\PhpSpreadsheet\Worksheet\AutoFilter\Column
Set AutoFilter Multiple Rules And/Or.
string | $pJoin | And/Or |
setAttributes(array<mixed,string> $attributes) : \PhpOffice\PhpSpreadsheet\Worksheet\AutoFilter\Column
Set AutoFilter Attributes.
array<mixed,string> | $attributes |
setAttribute(string $pName, string $pValue) : \PhpOffice\PhpSpreadsheet\Worksheet\AutoFilter\Column
Set An AutoFilter Attribute.
string | $pName | Attribute Name |
string | $pValue | Attribute Value |
getRules() : array<mixed,\PhpOffice\PhpSpreadsheet\Worksheet\AutoFilter\Column\Rule>
Get all AutoFilter Column Rules.
getRule(integer $pIndex) : \PhpOffice\PhpSpreadsheet\Worksheet\AutoFilter\Column\Rule
Get a specified AutoFilter Column Rule.
integer | $pIndex | Rule index in the ruleset array |
createRule() : \PhpOffice\PhpSpreadsheet\Worksheet\AutoFilter\Column\Rule
Create a new AutoFilter Column Rule in the ruleset.
addRule(\PhpOffice\PhpSpreadsheet\Worksheet\AutoFilter\Column\Rule $pRule) : \PhpOffice\PhpSpreadsheet\Worksheet\AutoFilter\Column
Add a new AutoFilter Column Rule to the ruleset.
\PhpOffice\PhpSpreadsheet\Worksheet\AutoFilter\Column\Rule | $pRule |
deleteRule(integer $pIndex) : \PhpOffice\PhpSpreadsheet\Worksheet\AutoFilter\Column
Delete a specified AutoFilter Column Rule If the number of rules is reduced to 1, then we reset And/Or logic to Or.
integer | $pIndex | Rule index in the ruleset array |
clearRules() : \PhpOffice\PhpSpreadsheet\Worksheet\AutoFilter\Column
Delete all AutoFilter Column Rules.