Class ExcelPivotTableAreaConditionalFormattingCollection¶
Namespace: OfficeOpenXml.Table.PivotTable
Assembly: EPPlus.dll
A collection of pivot areas used for conditional formatting
public class ExcelPivotTableAreaConditionalFormattingCollection : EPPlusReadOnlyList<ExcelPivotTableAreaConditionalFormatting>, IEnumerable<ExcelPivotTableAreaConditionalFormatting>, IEnumerable
Inheritance¶
object ← EPPlusReadOnlyList<ExcelPivotTableAreaConditionalFormatting> ← ExcelPivotTableAreaConditionalFormattingCollection
Implements¶
IEnumerable
IEnumerable<ExcelPivotTableAreaConditionalFormatting>
Inherited Members¶
EPPlusReadOnlyList<ExcelPivotTableAreaConditionalFormatting>.Count
EPPlusReadOnlyList<ExcelPivotTableAreaConditionalFormatting>.GetIndexByValue(ExcelPivotTableAreaConditionalFormatting)
EPPlusReadOnlyList<ExcelPivotTableAreaConditionalFormatting>.this[int]
object.Equals(object?, object?)
object.Equals(object?)
object.GetHashCode()
object.GetType()
object.MemberwiseClone()
object.ReferenceEquals(object?, object?)
object.ToString()
Methods¶
Add(params ExcelPivotTableDataField[])¶
Adds a new area for the one or more data fields
Parameters¶
fields ExcelPivotTableDataField[]
The data field(s) where the conditional formatting should be applied. If no fields are supplied all the pivot tables data fields will be added to the area
Returns¶
ExcelPivotTableAreaConditionalFormatting
The pivot area for the conditional formatting
Remove(ExcelPivotTableAreaConditionalFormatting)¶
/// Removes the the item from the collection
Parameters¶
item ExcelPivotTableAreaConditionalFormatting
The item to remove.
RemoveAt(int)¶
Removes the ExcelPivotTableAreaStyle at the index
Parameters¶
index int
The zero-based index in the collction to remove