ColorFilter

ColorFilter class

Represents filtering the range by color.

Properties

NameTypeDescription
FilterByFillColorbooleanWhether filter by the cell’s fill color. True: cell’s fill color; False: cell’s font color.

Methods

NameDescription
getColorGets the color of this filter.

ColorFilter.FilterByFillColor property

Whether filter by the cell’s fill color. True: cell’s fill color; False: cell’s font color.

Type: boolean

getColor(sheets)

Gets the color of this filter.

ParameterTypeDescription
sheetsWorksheetCollection