Excel.Interfaces.AutoFilterLoadOptions interface

Represents the AutoFilter object. AutoFilter turns the values in Excel column into specific filters based on the cell contents.

Remarks

[ API set: ExcelApi 1.9 ]

Properties

$all

Specifying $all for the load options loads all the scalar properties (such as Range.address) but not the navigational properties (such as Range.format.fill.color).

criteria

An array that holds all the filter criteria in the autofiltered range.

enabled

Specifies if the AutoFilter is enabled.

isDataFiltered

Specifies if the AutoFilter has filter criteria.

Property Details

$all

Specifying $all for the load options loads all the scalar properties (such as Range.address) but not the navigational properties (such as Range.format.fill.color).

$all?: boolean;

Property Value

boolean

criteria

An array that holds all the filter criteria in the autofiltered range.

criteria?: boolean;

Property Value

boolean

Remarks

[ API set: ExcelApi 1.9 ]

enabled

Specifies if the AutoFilter is enabled.

enabled?: boolean;

Property Value

boolean

Remarks

[ API set: ExcelApi 1.9 ]

isDataFiltered

Specifies if the AutoFilter has filter criteria.

isDataFiltered?: boolean;

Property Value

boolean

Remarks

[ API set: ExcelApi 1.9 ]