public final class HSSFAutoFilter extends java.lang.Object implements AutoFilter
Modifier and Type | Class and Description |
---|---|
class |
HSSFAutoFilter.HSSFFilterColumn |
FILTEROP_ABOVE_AVERAGE, FILTEROP_AND, FILTEROP_BELOW_AVERAGE, FILTEROP_BOTOOM10PERCENT, FILTEROP_BOTTOM10, FILTEROP_CELL_COLOR, FILTEROP_FONT_COLOR, FILTEROP_LAST_MONTH, FILTEROP_LAST_QUARTER, FILTEROP_LAST_WEEK, FILTEROP_LAST_YEAR, FILTEROP_M1, FILTEROP_M10, FILTEROP_M11, FILTEROP_M12, FILTEROP_M2, FILTEROP_M3, FILTEROP_M4, FILTEROP_M5, FILTEROP_M6, FILTEROP_M7, FILTEROP_M8, FILTEROP_M9, FILTEROP_NEXT_MONTH, FILTEROP_NEXT_QUARTER, FILTEROP_NEXT_WEEK, FILTEROP_NEXT_YEAR, FILTEROP_OR, FILTEROP_Q1, FILTEROP_Q2, FILTEROP_Q3, FILTEROP_Q4, FILTEROP_THIS_MONTH, FILTEROP_THIS_QUARTER, FILTEROP_THIS_WEEK, FILTEROP_THIS_YEAR, FILTEROP_TODAY, FILTEROP_TOMORROW, FILTEROP_TOP10, FILTEROP_TOP10PERCENT, FILTEROP_VALUES, FILTEROP_YEAR_TO_DATE, FILTEROP_YESTERDAY
Modifier and Type | Method and Description |
---|---|
FilterColumn |
getFilterColumn(int colId)
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.
|
FilterColumn |
getOrCreateFilterColumn(int colId) |
CellRangeAddress |
getRangeAddress()
Returns the filtered Range.
|
java.util.List<java.lang.String> |
getValuesOfFilter(int column) |
public java.util.List<java.lang.String> getValuesOfFilter(int column)
public CellRangeAddress getRangeAddress()
AutoFilter
getRangeAddress
in interface AutoFilter
public java.util.List<FilterColumn> getFilterColumns()
AutoFilter
getFilterColumns
in interface AutoFilter
public FilterColumn getFilterColumn(int colId)
AutoFilter
getFilterColumn
in interface AutoFilter
colId
- the nth column (1st column in the filter range is 0)public FilterColumn getOrCreateFilterColumn(int colId)
Copyright © 2005-2010 Potix Corporation. All Rights Reserved.