AutoFilter Class
Contents
[
Hide
]AutoFilter class
Represents autofiltering for the specified worksheet.
type AutoFilter struct {
ptr unsafe.Pointer
}
Constructors
| Method | Description |
|---|
Methods
| Method | Description |
|---|---|
| IsNull | Checks whether the implementation object is nullptr. |
| GetSorter | Gets the data sorter. |
| SetRange_Int_Int_Int | Sets the range to which the specified AutoFilter applies. |
| GetCellArea | Gets the CellArea where the this AutoFilter applies to. |
| GetCellArea_Bool | Gets the CellArea where the specified AutoFilter applies to. |
| GetRange | Represents the range to which the specified AutoFilter applies. |
| SetRange_String | Represents the range to which the specified AutoFilter applies. |
| AddFilter | Adds a filter for a filter column. |
| AddDateFilter | Adds a date filter. |
| RemoveDateFilter | Removes a date filter. |
| RemoveFilter_Int_String | Removes a filter for a filter column. |
| Filter | Filters a list with specified criteria. |
| FilterTop10 | Filter the top 10 item in the list |
| Dynamic_Filter | Adds a dynamic filter. |
| AddFontColorFilter | Adds a font color filter. |
| AddFillColorFilter | Adds a fill color filter. |
| AddIconFilter | Adds an icon filter. |
| MatchBlanks | Match all blank cell in the list. |
| MatchNonBlanks | Match all not blank cell in the list. |
| Custom_Int_FilterOperatorType_Object | Filters a list with a custom criteria. |
| Custom_Int_FilterOperatorType_Object_Bool_FilterOperatorType_Object | Filters a list with custom criteria. |
| ShowAll | Unhide all rows. |
| RemoveFilter_Int | Remove the specific filter. |
| Refresh | Refresh auto filters to hide or unhide the rows. |
| Refresh_Bool | Gets all hidden rows’ indexes. |
| GetShowFilterButton | Indicates whether the AutoFilter button for this column is visible. |
| SetShowFilterButton | Indicates whether the AutoFilter button for this column is visible. |
| GetFilterColumns | Gets the collection of the filter columns. |