Excel.Interfaces.AutoFilterLoadOptions interface
Represents the AutoFilter
object. AutoFilter turns the values in Excel column into specific filters based on the cell contents.
Remarks
Properties
$all | Specifying |
criteria | An array that holds all the filter criteria in the autofiltered range. |
enabled | Specifies if the AutoFilter is enabled. |
is |
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
enabled
Specifies if the AutoFilter is enabled.
enabled?: boolean;
Property Value
boolean
Remarks
isDataFiltered
Specifies if the AutoFilter has filter criteria.
isDataFiltered?: boolean;
Property Value
boolean
Remarks
Office Add-ins