Excel.Interfaces.FilterLoadOptions interface

Package:

excel

Manages the filtering of a table's column.

Remarks

[ API set: ExcelApi 1.2 ]

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	The currently applied filter on the given column.

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

The currently applied filter on the given column.

criteria?: boolean;

Property Value

boolean

Remarks

[ API set: ExcelApi 1.2 ]