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
Remarks
Collaborate with us on GitHub
The source for this content can be found on GitHub, where you can also create and review issues and pull requests. For more information, see our contributor guide.
Office Add-ins
Feedback
Coming soon: Throughout 2024 we will be phasing out GitHub Issues as the feedback mechanism for content and replacing it with a new feedback system. For more information see: https://aka.ms/ContentUserFeedback.
Submit and view feedback for