Home  Products  Purchase  Downloads  Demos  Forums  Blogs  Ticket  Wiki  API  Corporate

com.aspose.cells
Class AutoFilter

java.lang.Object
  extended by com.aspose.cells.AutoFilter

public class AutoFilter
extends java.lang.Object

Represents autofiltering for the specified worksheet.


Method Summary
 void filter(int fieldIndex, java.lang.String criteria)
          Filters a list with specified criteria.
 void setRange(CellArea ca)
          Sets cell range of auto filter.
 void showAll()
          Shows all items.
 
Methods inherited from class java.lang.Object
clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait
 

Method Detail

setRange

public void setRange(CellArea ca)
Sets cell range of auto filter.

Parameters:
ca - cell range of auto filter.
Throws:
java.lang.IllegalArgumentException - if cell range is null or cell range has one row.
CellsException - if worksheet has bean removed.

showAll

public void showAll()
Shows all items.

Throws:
CellsException - if worksheet has bean removed.

filter

public void filter(int fieldIndex,
                   java.lang.String criteria)
Filters a list with specified criteria.

Parameters:
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").
Throws:
java.lang.IllegalArgumentException - if field index of auto filter is out of range;
CellsException - if worksheet has bean removed.