Class ExcelPivotTableConditionalFormattingCollection

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

Inheritance
System.Object
EPPlusReadOnlyList<ExcelPivotTableConditionalFormatting>
ExcelPivotTableConditionalFormattingCollection
Implements
System.Collections.Generic.IEnumerable<ExcelPivotTableConditionalFormatting>
System.Collections.IEnumerable
Inherited Members
System.Object.Equals(System.Object)
System.Object.Equals(System.Object, System.Object)
System.Object.GetHashCode()
System.Object.GetType()
System.Object.MemberwiseClone()
System.Object.ReferenceEquals(System.Object, System.Object)
System.Object.ToString()
Namespace: OfficeOpenXml.Table.PivotTable
Assembly: EPPlus.dll
Syntax
public class ExcelPivotTableConditionalFormattingCollection : EPPlusReadOnlyList<ExcelPivotTableConditionalFormatting>, IEnumerable<ExcelPivotTableConditionalFormatting>, IEnumerable

Methods

Add(eExcelPivotTableConditionalFormattingRuleType, 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.

Declaration
public ExcelPivotTableConditionalFormatting Add(eExcelPivotTableConditionalFormattingRuleType ruleType, params ExcelPivotTableDataField[] fields)
Parameters
Type Name Description
eExcelPivotTableConditionalFormattingRuleType ruleType

The type of conditional formatting rule
ExcelPivotTableDataField[] fields

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
Type Description
ExcelPivotTableConditionalFormatting

The rule

Implements

System.Collections.Generic.IEnumerable<T>
System.Collections.IEnumerable