Skip to content

Class ExcelPivotTableConditionalFormattingCollection

Namespace: OfficeOpenXml.Table.PivotTable
Assembly: EPPlus.dll

A collection of pivot areas used for styling a pivot table.

public class ExcelPivotTableConditionalFormattingCollection : EPPlusReadOnlyList<ExcelPivotTableConditionalFormatting>, IEnumerable<ExcelPivotTableConditionalFormatting>, IEnumerable

Inheritance

object ← EPPlusReadOnlyList<ExcelPivotTableConditionalFormatting> ← ExcelPivotTableConditionalFormattingCollection

Implements

IEnumerable
IEnumerable<ExcelPivotTableConditionalFormatting>

Inherited Members

EPPlusReadOnlyList<ExcelPivotTableConditionalFormatting>.Count
EPPlusReadOnlyList<ExcelPivotTableConditionalFormatting>.GetIndexByValue(ExcelPivotTableConditionalFormatting)
EPPlusReadOnlyList<ExcelPivotTableConditionalFormatting>.this[int]
object.Equals(object?, object?)
object.Equals(object?)
object.GetHashCode()
object.GetType()
object.MemberwiseClone()
object.ReferenceEquals(object?, object?)
object.ToString()

Methods

Add(eExcelPivotTableConditionalFormattingRuleType, params ExcelPivotTableDataField[])

Adds a conditional formatting pivot area for the pivot tables data field(cf). Note that only conditional formattings for data is support. Conditional formattings for Lables, data buttons and other pivot areas must be added using the ConditionalFormatting collection.

public ExcelPivotTableConditionalFormatting Add(eExcelPivotTableConditionalFormattingRuleType ruleType, params ExcelPivotTableDataField[] fields)

Parameters

ruleType eExcelPivotTableConditionalFormattingRuleType

The type of conditional formatting rule

fields ExcelPivotTableDataField[]

The data field(cf) in the pivot table to apply the rule. If no data field is provided, all data field in the collection will be added to the area.The area will be added to the Areas collection

Returns

ExcelPivotTableConditionalFormatting

The rule