Edit

Excel.Interfaces.AutoFilterLoadOptions interface

  • Reference
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 ]

Properties

$all

Specifying $all for the LoadOptions loads all the scalar properties (e.g.: Range.address) but not the navigational properties (e.g.: 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 LoadOptions loads all the scalar properties (e.g.: Range.address) but not the navigational properties (e.g.: 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 ]