![]() |
||
Home Products Purchase Downloads Demos Forums Blogs Ticket Wiki API Corporate |
|
||||||||
PREV CLASS NEXT CLASS | FRAMES NO FRAMES | |||||||
SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD |
java.lang.Objectcom.aspose.cells.AutoFilter
public class AutoFilter
Represents autofiltering for the specified worksheet.
Method Summary | |
---|---|
void |
customFilter(int fieldIndex,
byte operator1,
java.lang.String criteria1)
Filters a list with custom criterias. |
void |
filter(int fieldIndex,
java.lang.String criteria)
Filters a list with specified criteria. |
void |
filterTop10(int fieldIndex,
boolean isTop,
boolean isPercent,
int numOfShownItems)
Filters the top 10 item in the list. |
void |
matchBlanks(int fieldIndex)
Filters a list with the blank cells. |
void |
matchNonBlanks(int fieldIndex)
Filters a list with the no_blank cells. |
void |
setRange(CellArea ca)
Sets cell range of auto filter. |
void |
showAll()
Shows all items. |
Methods inherited from class java.lang.Object |
---|
equals, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait |
Method Detail |
---|
public void setRange(CellArea ca)
ca
- cell range of auto filter.
java.lang.IllegalArgumentException
- if cell range is null.
CellsException
- if worksheet has bean removed.public void showAll()
CellsException
- if worksheet has bean removed.public void filter(int fieldIndex, java.lang.String criteria)
fieldIndex
- the integer offset of the field on which you want to base the filter(from the left of the list; the leftmost field is field 0).criteria
- The specified criteria (a string; for example, "101").
java.lang.IllegalArgumentException
- if field index of auto filter is out of range;
CellsException
- if worksheet has bean removed.public void matchBlanks(int fieldIndex)
fieldIndex
- the integer offset of the field on which you want to base the filter(from the left of the list; the leftmost field is field 0).public void matchNonBlanks(int fieldIndex)
fieldIndex
- the integer offset of the field on which you want to base the filter(from the left of the list; the leftmost field is field 0).public void filterTop10(int fieldIndex, boolean isTop, boolean isPercent, int numOfShownItems)
fieldIndex
- the integer offset of the field on which you want to base the filter(from the left of the list; the leftmost field is field 0).isTop
- whether filter from top(true) or bottom(false).isPercent
- whether the items is percent(true) or count(false).numOfShownItems
- item count or percentage value.public void customFilter(int fieldIndex, byte operator1, java.lang.String criteria1)
fieldIndex
- operator1
- criteria1
-
|
||||||||
PREV CLASS NEXT CLASS | FRAMES NO FRAMES | |||||||
SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD |