FilterColumnCollection

FilterColumnCollection class

A collection of Filter objects that represents all the filters in an autofiltered range.

class FilterColumnCollection;

Methods

MethodDescription
get(number)Gets FilterColumn object at the special field.
removeAt(number)
getByIndex(number)Returns a single Filter object from a collection.
getCount()Gets the number of elements contained in.
isNull()Checks whether the implementation object is null.

get(number)

Gets FilterColumn object at the special field.

get(fieldIndex: number) : FilterColumn;

Parameters:

ParameterTypeDescription
fieldIndexnumberThe integer offset of the field on which you want to base the filter /// (from the left of the list; the leftmost field is field 0).

Returns

Returns FilterColumn object.

removeAt(number)

removeAt(index: number) : void;

Parameters:

ParameterTypeDescription
indexnumber

getByIndex(number)

Returns a single Filter object from a collection.

getByIndex(index: number) : FilterColumn;

Parameters:

ParameterTypeDescription
indexnumber

Returns

FilterColumn

getCount()

Gets the number of elements contained in.

getCount() : number;

isNull()

Checks whether the implementation object is null.

isNull() : boolean;