PivotConditionalFormatCollection

PivotConditionalFormatCollection class

Represents all conditional formats of pivot table.

class PivotConditionalFormatCollection implements Iterable<PivotConditionalFormat>;

Methods

MethodDescription
get(number)Gets the pivot FormatCondition object at the specific index.
add()Adds a pivot FormatCondition to the collection.
getCount()@deprecated. Please use the ‘count’ property instead. Gets the number of elements contained in.
isNull()Checks whether the implementation object is null.

[Symbol.iterator](): Iterator<PivotConditionalFormat>

Returns an iterator over the items in the collection. Enables use of for...of, spread syntax, and Array.from().

get(number)

Gets the pivot FormatCondition object at the specific index.

get(index: number) : PivotConditionalFormat;

Parameters:

ParameterTypeDescription
indexnumber

Returns

pivot FormatCondition object.

add()

Adds a pivot FormatCondition to the collection.

add() : number;

Returns

pivot FormatCondition object index.

Remarks

not supported

getCount()

@deprecated. Please use the ‘count’ property instead. Gets the number of elements contained in.

getCount() : number;

isNull()

Checks whether the implementation object is null.

isNull() : boolean;