autoFilter(boolean,int,Object) Method

In This Topic

Filters a list using the AutoFilter.

Syntax

void autoFilter( 
   boolean isFirstRowData,
   int field,
   java.lang.Object criteria1
)

isFirstRowData: Indicates whether the first row of the selection area participates in filtering.When set to true, the behavior is consistent with SpreadJS; when false, it is consistent with Microsoft Excel.
field: Optional Object. The integer offset of the field on whichyou want to base the filter (from the left of the list; the leftmost field is field zero).
criteria1: Optional Object. The criteria (a string; for example,"101"). Use "=" to find blank fields, or use " @literal:<>" to find nonblank fields. If this argument is omitted, the criteria is All. If Operator is xlTop10Items, Criteria1 specifies the number of items (for example, "10").