Class ExcelPivotTableConditionalFormattingCollection
A collection of pivot areas used for styling a pivot table.
Inheritance
System.Object
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>, IEnumerableMethods
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