ApiAutoFilter

Represents the ApiAutoFilter class.

Properties

Name	Type	Description
FilterMode	boolean	Returns a value that indicates whether the worksheet has an AutoFilter applied.
Filters	ApiFilter[]	Returns the array of ApiFilter objects that represents the filters applied to the range.
Parent	ApiWorksheet	Returns the ApiWorksheet object that contains the AutoFilter.
Range	ApiRange | null	Returns the ApiRange object that represents the AutoFilter range; null if no AutoFilter is defined.

Methods

Method	Returns	Description
ApplyFilter	void	Reapplies the AutoFilter to the worksheet using the existing filter criteria.
GetFilterMode	boolean	Returns a value that indicates whether the worksheet has an AutoFilter applied.
GetFilters	ApiFilter[]	Returns the array of ApiFilter objects that represents the filters applied to the AutoFilter range.
GetParent	ApiWorksheet	Returns the parent ApiWorksheet object for the AutoFilter.
GetRange	ApiRange | null	Returns the ApiRange object that represents the AutoFilter range.
ShowAllData	void	Clears all filters and displays all rows in the AutoFilter range.