Edit

Excel.Interfaces.AutoFilterLoadOptions interface

Package:
excel

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

Used by

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