public interface AutoFilter
Filtering data is a quick and easy way to find and work with a subset of data in a range of cells or table. For example, you can filter to see only the values that you specify, filter to see the top or bottom values, or filter to quickly see duplicate values.
TODO YK: For now (Aug 2010) POI only supports setting a basic autofilter on a range of cells. In future, when we support more auto-filter functions like custom criteria, sort, etc. we will add corresponding methods to this interface.Modifier and Type | Field and Description |
---|---|
static int |
FILTEROP_AND
Apply a filter against a list of values
Example:
AutoFilter filter = sheet.setAutoFilter(CellRangeAddress.valueOf("A1:F200"));
filter.applyFilter(0, "apache", "poi", "java", "api");
|
static int |
FILTEROP_BOTOOM10PERCENT |
static int |
FILTEROP_BOTTOM10 |
static int |
FILTEROP_OR |
static int |
FILTEROP_TOP10 |
static int |
FILTEROP_TOP10PERCENT |
static int |
FILTEROP_VALUES |
Modifier and Type | Method and Description |
---|---|
FilterColumn |
getFilterColumn(int col)
Returns the column filter information of the specified column; null if the column is not filtered.
|
java.util.List<FilterColumn> |
getFilterColumns()
Return filter setting of each filtered column.
|
CellRangeAddress |
getRangeAddress()
Returns the filtered Range.
|
static final int FILTEROP_AND
Example:
AutoFilter filter = sheet.setAutoFilter(CellRangeAddress.valueOf("A1:F200")); filter.applyFilter(0, "apache", "poi", "java", "api");
static final int FILTEROP_BOTTOM10
static final int FILTEROP_BOTOOM10PERCENT
static final int FILTEROP_OR
static final int FILTEROP_TOP10
static final int FILTEROP_TOP10PERCENT
static final int FILTEROP_VALUES
CellRangeAddress getRangeAddress()
java.util.List<FilterColumn> getFilterColumns()
FilterColumn getFilterColumn(int col)
col
- the nth column (1st column in the filter range is 0)Copyright © 2005-2010 Potix Corporation. All Rights Reserved.