Constants

AUTOFILTER_FILTERTYPE_FILTER

AUTOFILTER_FILTERTYPE_FILTER = 'filters'

AUTOFILTER_FILTERTYPE_CUSTOMFILTER

AUTOFILTER_FILTERTYPE_CUSTOMFILTER = 'customFilters'

AUTOFILTER_FILTERTYPE_DYNAMICFILTER

AUTOFILTER_FILTERTYPE_DYNAMICFILTER = 'dynamicFilter'

AUTOFILTER_FILTERTYPE_TOPTENFILTER

AUTOFILTER_FILTERTYPE_TOPTENFILTER = 'top10'

AUTOFILTER_COLUMN_JOIN_AND

AUTOFILTER_COLUMN_JOIN_AND = 'and'

AUTOFILTER_COLUMN_JOIN_OR

AUTOFILTER_COLUMN_JOIN_OR = 'or'

Properties

$_filterTypes

$_filterTypes : array<mixed,string>

Types of autofilter rules

Type

array<mixed,string>

$_ruleJoins

$_ruleJoins : array<mixed,string>

Join options for autofilter rules

Type

array<mixed,string>

$_columnIndex

$_columnIndex : string

Autofilter Column Index

Type

string

$_filterType

$_filterType : string

Autofilter Column Filter Type

Type

string

$_join

$_join : string

Autofilter Multiple Rules And/Or

Type

string

$_ruleset

$_ruleset : array

Autofilter Column Rules

Type

array — of PHPExcel_Worksheet_AutoFilter_Column_Rule

$_attributes

$_attributes : array

Autofilter Column Dynamic Attributes

Type

array — of mixed

Methods

__construct()

__construct(string  $pColumn, \PHPExcel_Worksheet_AutoFilter  $pParent = NULL) 

Create a new PHPExcel_Worksheet_AutoFilter_Column

Parameters

string $pColumn

Column (e.g. A)

\PHPExcel_Worksheet_AutoFilter $pParent

Autofilter for this column

getColumnIndex()

getColumnIndex() : string

Get AutoFilter Column Index

Returns

string

setColumnIndex()

setColumnIndex(string  $pColumn) : \PHPExcel_Worksheet_AutoFilter_Column

Set AutoFilter Column Index

Parameters

string $pColumn

Column (e.g. A)

Throws

\PHPExcel_Exception

Returns

\PHPExcel_Worksheet_AutoFilter_Column

getFilterType()

getFilterType() : string

Get AutoFilter Type

Returns

string

setFilterType()

setFilterType(string  $pFilterType = self::AUTOFILTER_FILTERTYPE_FILTER) : \PHPExcel_Worksheet_AutoFilter_Column

Set AutoFilter Type

Parameters

string $pFilterType

Throws

\PHPExcel_Exception

Returns

\PHPExcel_Worksheet_AutoFilter_Column

getJoin()

getJoin() : string

Get AutoFilter Multiple Rules And/Or Join

Returns

string

setJoin()

setJoin(string  $pJoin = self::AUTOFILTER_COLUMN_JOIN_OR) : \PHPExcel_Worksheet_AutoFilter_Column

Set AutoFilter Multiple Rules And/Or

Parameters

string $pJoin

And/Or

Throws

\PHPExcel_Exception

Returns

\PHPExcel_Worksheet_AutoFilter_Column

setAttributes()

setAttributes(array<mixed,string>  $pAttributes = array()) : \PHPExcel_Worksheet_AutoFilter_Column

Set AutoFilter Attributes

Parameters

array<mixed,string> $pAttributes

Throws

\PHPExcel_Exception

Returns

\PHPExcel_Worksheet_AutoFilter_Column

setAttribute()

setAttribute(string  $pName, string  $pValue) : \PHPExcel_Worksheet_AutoFilter_Column

Set An AutoFilter Attribute

Parameters

string $pName

Attribute Name

string $pValue

Attribute Value

Throws

\PHPExcel_Exception

Returns

\PHPExcel_Worksheet_AutoFilter_Column

getAttributes()

getAttributes() : string

Get AutoFilter Column Attributes

Returns

string

getAttribute()

getAttribute(string  $pName) : string

Get specific AutoFilter Column Attribute

Parameters

string $pName

Attribute Name

Returns

string

getRules()

getRules() : array

Get all AutoFilter Column Rules

Throws

\PHPExcel_Exception

Returns

array —

of PHPExcel_Worksheet_AutoFilter_Column_Rule

getRule()

getRule(integer  $pIndex) : \PHPExcel_Worksheet_AutoFilter_Column_Rule

Get a specified AutoFilter Column Rule

Parameters

integer $pIndex

Rule index in the ruleset array

Returns

\PHPExcel_Worksheet_AutoFilter_Column_Rule

deleteRule()

deleteRule(integer  $pIndex) : \PHPExcel_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

Parameters

integer $pIndex

Rule index in the ruleset array

Returns

\PHPExcel_Worksheet_AutoFilter_Column

__clone()

__clone() 

Implement PHP __clone to create a deep clone, not just a shallow copy.