autofilterscollection-ag凯发旗舰厅

com.spire.xls.collections
class autofilterscollection

java.lang.object
  com.spire.ms.system.collections.collectionbase
      
          com.spire.xls.core.spreadsheet.collections.xlsautofilterscollection
              com.spire.xls.collections.autofilterscollection

all implemented interfaces:

com.spire.ms.system.collections.icollection, com.spire.ms.system.collections.ienumerable, java.lang.iterable

public class autofilterscollection
extends xlsautofilterscollection

autofilterscollection

public autofilterscollection(java.lang.object parent)

getworksheet

public worksheet getworksheet()

returns parent worksheet. read-only.

overrides:

getworksheet in class xlsautofilterscollection

returns:

getforiautofilter

public iautofilter getforiautofilter(int columnindex)

get auto filter item..

getrange

public cellrange getrange()

range to be filtered.

overrides:

getrange in class xlsautofilterscollection

returns:

setrange

public void setrange(cellrange range)

sets range to be filtered.

parameters:

range -

filter

public void filter()

filter the data.

addfilter

public void addfilter(int columnindex,
                      java.lang.string criteria)

adds a filter for a filter column.

parameters:

columnindex - the column field on which you want to base the filter . for exapmle: sheet.autofilters[0]

criteria - the specified criteria (a string; for example, "hello the specified criteria (a string; for example, "hello"). it only can be null or be one of the cells' value in this column.

addfilter

public void addfilter(iautofilter column,
                      java.lang.string criteria)

adddatefilter

public void adddatefilter(int columnindex,
                          datetimegroupingtype datetimegroupingtype,
                          int year,
                          int month,
                          int day,
                          int hour,
                          int minute,
                          int second)

adds a date filter for a filter column.

parameters:

columnindex - the column field on which you want to base the filter . for exapmle: sheet.autofilters[0]

datetimegroupingtype - datetimegroupingtype

year - the year.

month - the month.

day - the day.

hour - the hour.

minute - the minute.

second - the second.

removedatefilter

public void removedatefilter(int columnindex,
                             datetimegroupingtype datetimegroupingtype,
                             int year,
                             int month,
                             int day,
                             int hour,
                             int minute,
                             int second)

removes a date filter.

parameters:

columnindex - the column field on which you want to base the filter . for exapmle: sheet.autofilters[0]

datetimegroupingtype - datetimegroupingtype

year - the year.

month - the month.

day - the day.

hour - the hour.

minute - the minute.

second - the second.

removefilter

public void removefilter(int columnindex,
                         java.lang.string criteria)

removes a filter for a filter column.

parameters:

columnindex - the column field on which you want to base the filter . for exapmle: sheet.autofilters[0]

criteria - the specified criteria (a string; for example, "hello the specified criteria (a string; for example, "hello"). it only can be null or be one of the cells' value in this column.

quickfilter

public void quickfilter(int columnindex,
                        java.lang.string criteria)

filters a list with specified criteria.

parameters:

columnindex - the column field on which you want to base the filter . for exapmle: sheet.autofilters[0]

criteria - the specified criteria (a string; for example, "hello the specified criteria (a string; for example, "hello").

quickfilter

public void quickfilter(iautofilter column,
                        java.lang.string criteria)

dynamicfilter

public void dynamicfilter(int columnindex,
                          dynamicfiltertype dynamicfiltertype)

adds a dynamic filter.

parameters:

columnindex - the column field on which you want to base the filter. for exapmle: sheet.autofilters[0]

dynamicfiltertype - dynamic filter type.

addfontcolorfilter

public void addfontcolorfilter(filtercolumn filtercolumn,
                               java.awt.color color)

adds a font color filter.

parameters:

filtercolumn - the column field on which you want to base the filter. for exapmle: sheet.autofilters[0]

color - font color.

addfillcolorfilter

public void addfillcolorfilter(int columnindex,
                               excelpatterntype pattern,
                               java.awt.color forecolor,
                               java.awt.color backcolor)

adds a fill color filter.

parameters:

columnindex - the column field on which you want to base the filter. for exapmle: sheet.autofilters[0]

pattern - the background pattern type.

forecolor - the foreground color.

backcolor - the background color.

addfillcolorfilter

public void addfillcolorfilter(filtercolumn filtercolumn,
                               excelpatterntype pattern,
                               java.awt.color forecolor,
                               java.awt.color backcolor)

addfillcolorfilter

public void addfillcolorfilter(int filtercolumnindex,
                               java.awt.color color)

adds a fill color filter.

parameters:

filtercolumnindex - the column field index on which you want to base the filter (from the left of the list; the leftmost field is field 0).

color - fill color.

addfillcolorfilter

public void addfillcolorfilter(filtercolumn filtercolumn,
                               java.awt.color color)

addiconfilter

public void addiconfilter(int columnindex,
                          iconsettype iconsettype,
                          int iconid)

adds an icon filter.

parameters:

columnindex - the column field on which you want to base the filter. for exapmle: sheet.autofilters[0]

iconsettype - the icon set type.

iconid - the icon id.

matchblanks

public void matchblanks(int columnindex)

match all blank cell in the list.

parameters:

columnindex - the column field on which you want to base the filter . for exapmle: sheet.autofilters[0]

matchblanks

public void matchblanks(iautofilter column)

match all blank cell in the list.

parameters:

column - the column field on which you want to base the filter . for exapmle: sheet.autofilters[0]

customfilter

public void customfilter(int columnindex,
                         filteroperatortype operatortype,
                         java.lang.object criteria)

filters a list with a custom criteria.

parameters:

columnindex - the column field on which you want to base the filter . for exapmle: sheet.autofilters[0]

operatortype - the filter operator type

criteria - the custom criteria

customfilter

public void customfilter(int columnindex,
                         filteroperatortype operatortype1,
                         java.lang.object criteria1,
                         boolean isand,
                         filteroperatortype operatortype2,
                         java.lang.object criteria2)

filters a list with custom criterias.

parameters:

columnindex - the column field on which you want to base the filter. for exapmle: sheet.autofilters[0]

operatortype1 - the first filter operator type

criteria1 - the first custom criteria

isand -

operatortype2 - the second filter operator type

criteria2 - the second custom criteria

customfilter

public void customfilter(filtercolumn column,
                         filteroperatortype operatortype,
                         java.lang.object criteria)

customfilter

public void customfilter(filtercolumn column,
                         filteroperatortype operatortype1,
                         java.lang.object criteria1,
                         boolean isand,
                         filteroperatortype operatortype2,
                         java.lang.object criteria2)

dynamicfilter

public void dynamicfilter(iautofilter column,
                          dynamicfiltertype dynamicfiltertype)

clearfilter

public void clearfilter(java.lang.string columnname)

delete the column filter by column name

parameters:

columnname - column name

clearfilter

public void clearfilter(int filtercolumnindex)

delete the column filter by column index(filters column index not sheet column index)

parameters:

filtercolumnindex - column index

adddatefilter

public void adddatefilter(iautofilter column,
                          datetimegroupingtype datetimegroupingtype,
                          int year,
                          int month,
                          int day,
                          int hour,
                          int minute,
                          int second)

filtertop10

public void filtertop10(int filtercolumnindex,
                        boolean istop,
                        boolean ispercent,
                        int itemcount)

filter the top 10 item in the list

parameters:

filtercolumnindex - the column field index on which you want to base the filter (from the left of the list; the leftmost field is field 0).

istop - indicates whether filter from top or bottom

ispercent - indicates whether the items is percent or count

itemcount - the item count

filtertop10

public void filtertop10(iautofilter column,
                        boolean istop,
                        boolean ispercent,
                        int itemcount)

filter the top 10 item in the list

parameters:

column - the column field on which you want to base the filter. for exapmle: sheet.autofilters[0]

istop - indicates whether filter from top or bottom

ispercent - indicates whether the items is percent or count

itemcount - the item count

matchnonblanks

public void matchnonblanks(int filtercolumnindex)

match all not blank cell in the list.

parameters:

filtercolumnindex - the column field index on which you want to base the filter (from the left of the list; the leftmost field is field 0).

matchnonblanks

public void matchnonblanks(filtercolumn column)

match all not blank cell in the list.

parameters:

column - the column field on which you want to base the filter . for exapmle: sheet.autofilters[0]

clear

public void clear()

overrides:

clear in class com.spire.ms.system.collections.collectionbase