FilterCollection

12 Sep 20251 minute to read

Represents the Filter Collection.

Properties

column number[]

Specifies the filtered column collection.

Defaults to []

criteria string[]

Specifies the condition for column filtering.

Defaults to []

dataType string[]

Specifies the data type of column filtering.

Defaults to []

filterRange string

Specifies the range of the filter collection.

Defaults to []

hasFilter boolean

Specifies the sheet has filter or not.

Defaults to false

predicates string[]

Specifies the predicate type of column filtering.

Defaults to []

sheetIndex number

Specifies the sheet index of the filter collection.

Defaults to null

value []

Specifies the value for column filtering.

Defaults to []