AutoFilter
Overview
AutoFilter is a class in Aspose.Cells FOSS for Java.
Represents an auto-filter in a worksheet.
This class provides 5 methods for working with AutoFilter objects in Java programs.
Available methods include: clear, getFilterColumns, getRange, getSortState, setRange.
All exported members are accessible to any Java application after installing the Aspose.Cells FOSS for Java package.
Properties: filterColumns, range, sortState.
Properties
| Name | Type | Access | Description |
|---|---|---|---|
range | String | Read | Returns the range. |
filterColumns | FilterColumnCollection | Read | Returns the filter columns. |
sortState | AutoFilterSortState | Read | Returns the sort state. |
Methods
| Signature | Description |
|---|---|
getRange() → String | Returns the range. |
setRange(value: String) | Sets the range. |
getFilterColumns() → FilterColumnCollection | Returns the filter columns. |
getSortState() → AutoFilterSortState | Returns the sort state. |
clear() | Clears the current state maintained by this object. |