Excel.Interfaces.FilterLoadOptions interface

  • Reference
Package:
excel

Warning

This API is now deprecated.

Manages the filtering of a table's column.

Remarks

[ API set: ExcelApi 1.2 ]

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

The currently applied filter on the given column.

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.

The currently applied filter on the given column.

criteria?: boolean;

Property Value

boolean

Remarks

[ API set: ExcelApi 1.2 ]