Class ExcelPivotTableConditionalFormattingCollection

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

Inheritance
object
EPPlusReadOnlyList<ExcelPivotTableConditionalFormatting>
ExcelPivotTableConditionalFormattingCollection
Implements
Inherited Members
Namespace: OfficeOpenXml.Table.PivotTable
Assembly: EPPlus.dll
Syntax
public class ExcelPivotTableConditionalFormattingCollection : EPPlusReadOnlyList<ExcelPivotTableConditionalFormatting>, IEnumerable<ExcelPivotTableConditionalFormatting>, IEnumerable

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.

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