iconditionalformatscollection-j9官方网址

com.spire.xls.core
interface iconditionalformatscollection

all known implementing classes:

worksheetconditionalformats, xlsworksheetconditionalformats

public interface iconditionalformatscollection

represents iconditionalformatscollection.

get

xlsconditionalformats get(int fieldindex)

gets object at the special field.

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).

returns:

returens object.

add

xlsconditionalformats add()

adds new item to the collection.

returns:

add

xlsconditionalformats add(xlsconditionalformats formats)

adds new item to the collection.

parameters:

formats - item to add.

returns:

object that contains required cells.

copyfrom

void copyfrom(xlsworksheetconditionalformats srcformats)

copies conditional formats from another formats collection.

parameters:

srcformats - source collection of conditional formats to copy.

find

xlsconditionalformats find(java.awt.rectangle[] arrranges)

search for collection that contains all specified ranges.

parameters:

arrranges -

returns:

findall

xlsconditionalformats[] findall(java.awt.rectangle[] arrranges)

getbyindex

xlsconditionalformats getbyindex(int index)

returns a single filter object from a collection.

remove

void remove(java.awt.rectangle[] arrranges)

removes range from the collection of conditional formats.

parameters:

arrranges - array of ranges to remove.

removeat

void removeat(int index)

parameters:

index -