Excel.Interfaces.AutoFilterData interface
An interface describing the data returned by calling autoFilter.toJSON().
Properties
| 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
criteria
An array that holds all the filter criteria in the autofiltered range.
criteria?: Excel.FilterCriteria[];Property Value
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