Class ExcelPivotTableAreaConditionalFormattingCollection

A collection of pivot areas used for conditional formatting

Inheritance
System.Object
EPPlusReadOnlyList<ExcelPivotTableAreaConditionalFormatting>
ExcelPivotTableAreaConditionalFormattingCollection
Implements
System.Collections.Generic.IEnumerable<ExcelPivotTableAreaConditionalFormatting>
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 ExcelPivotTableAreaConditionalFormattingCollection : EPPlusReadOnlyList<ExcelPivotTableAreaConditionalFormatting>, IEnumerable<ExcelPivotTableAreaConditionalFormatting>, IEnumerable

Methods

Add(ExcelPivotTableDataField[])

Adds a new area for the one or more data fields

Declaration
public ExcelPivotTableAreaConditionalFormatting Add(params ExcelPivotTableDataField[] fields)
Parameters
Type Name Description
ExcelPivotTableDataField[] fields

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

The pivot area for the conditional formatting

Remove(ExcelPivotTableAreaConditionalFormatting)

/// Removes the the item from the collection

Declaration
public void Remove(ExcelPivotTableAreaConditionalFormatting item)
Parameters
Type Name Description
ExcelPivotTableAreaConditionalFormatting item

The item to remove.

RemoveAt(Int32)

Removes the ExcelPivotTableAreaStyle at the index

Declaration
public void RemoveAt(int index)
Parameters
Type Name Description
System.Int32 index

The zero-based index in the collction to remove

Implements

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