Class ExcelPivotTableConditionalFormatting¶

Namespace: OfficeOpenXml.Table.PivotTable
Assembly: EPPlus.dll

Defines a pivot table area of selection used for styling.

public class ExcelPivotTableConditionalFormatting : XmlHelper

Inheritance¶

object ← XmlHelper ← ExcelPivotTableConditionalFormatting

Inherited Members¶

object.Equals(object?, object?)
object.Equals(object?)
object.GetHashCode()
object.GetType()
object.MemberwiseClone()
object.ReferenceEquals(object?, object?)
object.ToString()

Properties¶

Areas¶

A collection of conditions for the conditional formattings. Conditions can be set for specific row-, column- or data fields. Specify labels, data grand totals and more.

public ExcelPivotTableAreaConditionalFormattingCollection Areas { get; }

Property Value¶

ExcelPivotTableAreaConditionalFormattingCollection

ConditionalFormatting¶

Access to the style property for the pivot area

public IExcelConditionalFormattingRule ConditionalFormatting { get; }

Property Value¶

IExcelConditionalFormattingRule

Scope¶

The scope of the pivot table conditional formatting rule. Default is Selection.

public ConditionScope Scope { get; set; }

Property Value¶

ConditionScope

Type¶

The condition type of the pivot table conditional formatting rule. Default is None. This property only apply to condional formattings for above/below -average, -stdev amd top or bottom.

public ConditionType Type { get; set; }

Property Value¶

ConditionType

Exceptions¶

InvalidOperationException

If setting this property to Row or Column when having an unsupported conditional formatting rule.