Options
All
  • Public
  • Public/Protected
  • All
Menu

Interface IAutoFilter

com.aspose.cells.AutoFilter

Hierarchy 层级

  • IAutoFilter

Index 目录

Methods 方法

Methods 方法

addDateFilter

  • addDateFilter(fieldIndex: number, dateTimeGroupingType: number, year: number, month: number, day: number, hour: number, minute: number, second: number): void

  • void addDateFilter(int, int, int, int, int, int, int, int)

    Parameters 参数

    • fieldIndex: number
    • dateTimeGroupingType: number
    • year: number
    • month: number
    • day: number
    • hour: number
    • minute: number
    • second: number

    Returns 返回值 void

addFillColorFilter

  • addFillColorFilter(fieldIndex: number, pattern: number, foregroundColor: ICellsColor, backgroundColor: ICellsColor): void

  • void addFillColorFilter(int, int, com.aspose.cells.CellsColor, com.aspose.cells.CellsColor)

    Parameters 参数

    Returns 返回值 void

addFilter

  • addFilter(fieldIndex: number, criteria: string): void

  • void addFilter(int, java.lang.String)

    Parameters 参数

    • fieldIndex: number
    • criteria: string

    Returns 返回值 void

addFontColorFilter

  • addFontColorFilter(fieldIndex: number, color: ICellsColor): void

  • void addFontColorFilter(int, com.aspose.cells.CellsColor)

    Parameters 参数

    Returns 返回值 void

addIconFilter

  • addIconFilter(fieldIndex: number, iconSetType: number, iconId: number): void

  • void addIconFilter(int, int, int)

    Parameters 参数

    • fieldIndex: number
    • iconSetType: number
    • iconId: number

    Returns 返回值 void

custom

  • custom(fieldIndex: number, operatorType1: number, criteria1: any): void
  • custom(fieldIndex: number, operatorType1: number, criteria1: any, isAnd: boolean, operatorType2: number, criteria2: any): void

  • void custom(int, int, java.lang.Object)

    Parameters 参数

    • fieldIndex: number
    • operatorType1: number
    • criteria1: any

    Returns 返回值 void

  • void custom(int, int, java.lang.Object, boolean, int, java.lang.Object)

    Parameters 参数

    • fieldIndex: number
    • operatorType1: number
    • criteria1: any
    • isAnd: boolean
    • operatorType2: number
    • criteria2: any

    Returns 返回值 void

dynamicFilter

  • dynamicFilter(fieldIndex: number, dynamicFilterType: number): void

  • void dynamicFilter(int, int)

    Parameters 参数

    • fieldIndex: number
    • dynamicFilterType: number

    Returns 返回值 void

filter

  • filter(fieldIndex: number, criteria: string): void

  • void filter(int, java.lang.String)

    Parameters 参数

    • fieldIndex: number
    • criteria: string

    Returns 返回值 void

filterTop10

  • filterTop10(fieldIndex: number, isTop: boolean, isPercent: boolean, itemCount: number): void

  • void filterTop10(int, boolean, boolean, int)

    Parameters 参数

    • fieldIndex: number
    • isTop: boolean
    • isPercent: boolean
    • itemCount: number

    Returns 返回值 void

getFilterColumns

getRange

  • getRange(): string

  • java.lang.String getRange()

    Returns 返回值 string

getSorter

  • com.aspose.cells.DataSorter getSorter()

    Returns 返回值 IDataSorter

matchBlanks

  • matchBlanks(fieldIndex: number): void

  • void matchBlanks(int)

    Parameters 参数

    • fieldIndex: number

    Returns 返回值 void

matchNonBlanks

  • matchNonBlanks(fieldIndex: number): void

  • void matchNonBlanks(int)

    Parameters 参数

    • fieldIndex: number

    Returns 返回值 void

refresh

  • refresh(): number[]
  • refresh(hideRows: boolean): number[]

  • int[] refresh()

    Returns 返回值 number[]

  • int[] refresh(boolean)

    Parameters 参数

    • hideRows: boolean

    Returns 返回值 number[]

removeDateFilter

  • removeDateFilter(fieldIndex: number, dateTimeGroupingType: number, year: number, month: number, day: number, hour: number, minute: number, second: number): void

  • void removeDateFilter(int, int, int, int, int, int, int, int)

    Parameters 参数

    • fieldIndex: number
    • dateTimeGroupingType: number
    • year: number
    • month: number
    • day: number
    • hour: number
    • minute: number
    • second: number

    Returns 返回值 void

removeFilter

  • removeFilter(fieldIndex: number): void
  • removeFilter(fieldIndex: number, criteria: string): void

  • void removeFilter(int)

    Parameters 参数

    • fieldIndex: number

    Returns 返回值 void

  • void removeFilter(int, java.lang.String)

    Parameters 参数

    • fieldIndex: number
    • criteria: string

    Returns 返回值 void

setRange

  • setRange(row: number, startColumn: number, endColumn: number): void
  • setRange(value: string): void

  • void setRange(int, int, int)

    Parameters 参数

    • row: number
    • startColumn: number
    • endColumn: number

    Returns 返回值 void

  • void setRange(java.lang.String)

    Parameters 参数

    • value: string

    Returns 返回值 void

showAll

  • showAll(): void

  • void showAll()

    Returns 返回值 void