Class ExcelPivotTableFilter

Defines a pivot table filter

Inheritance

object

XmlHelper

ExcelPivotTableFilter

Inherited Members

object.Equals(object)

object.Equals(object, object)

object.GetHashCode()

object.GetType()

object.MemberwiseClone()

object.ReferenceEquals(object, object)

object.ToString()

Namespace: OfficeOpenXml.Table.PivotTable.Filter

Assembly: EPPlus.dll

Syntax

public class ExcelPivotTableFilter : XmlHelper

Properties

Description

The description of the pivot filter

Declaration

public string Description { get; set; }

Property Value

Type	Description
string

EvalOrder

The evaluation order of the pivot filter

Declaration

public int EvalOrder { get; }

Property Value

Type	Description
int

Id

The id

Declaration

public int Id { get; }

Property Value

Type	Description
int

Name

The name of the pivot filter

Declaration

public string Name { get; set; }

Property Value

Type	Description
string

Type

The type of pivot filter

Declaration

public ePivotTableFilterType Type { get; }

Property Value

Type	Description
ePivotTableFilterType

Value1

The valueOrIndex 1 to compare the filter to

Declaration

public object Value1 { get; set; }

Property Value

Type	Description
object

Value2

The valueOrIndex 2 to compare the filter to

Declaration

public object Value2 { get; set; }

Property Value

Type	Description
object