Excel.Interfaces.AutoFilterLoadOptions interface

  • Reference
Package:
excel

Warning

This API is now deprecated.

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

Warning

This API is now deprecated.

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

Warning

This API is now deprecated.

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

criteria?: boolean;

Property Value

boolean

Remarks

[ API set: ExcelApi 1.9 ]

enabled

Warning

This API is now deprecated.

Specifies if the AutoFilter is enabled.

enabled?: boolean;

Property Value

boolean

Remarks

[ API set: ExcelApi 1.9 ]

isDataFiltered

Warning

This API is now deprecated.

Specifies if the AutoFilter has filter criteria.

isDataFiltered?: boolean;

Property Value

boolean

Remarks

[ API set: ExcelApi 1.9 ]