Class ExcelTop10FilterColumn

A filter column filtered by the top or botton values of an range

Inheritance

Object

XmlHelper

ExcelFilterColumn

ExcelTop10FilterColumn

Inherited Members

ExcelFilterColumn.GetFilterValue(String)

ExcelFilterColumn.Position

ExcelFilterColumn.HiddenButton

ExcelFilterColumn.ShowButton

Object.Equals(Object)

Object.Equals(Object, Object)

Object.GetHashCode()

Object.GetType()

Object.MemberwiseClone()

Object.ReferenceEquals(Object, Object)

Object.ToString()

Namespace: OfficeOpenXml.Filter

Assembly: EPPlus.dll

Syntax

public class ExcelTop10FilterColumn : ExcelFilterColumn

Properties

FilterValue

The filter value to relate to

Declaration

public double FilterValue { get; }

Property Value

Type	Description
Double

Percent

If the filter value is an percentage

Declaration

public bool Percent { get; set; }

Property Value

Type	Description
Boolean

Top

True is top value. False is bottom values.

Declaration

public bool Top { get; set; }

Property Value

Type	Description
Boolean

Value

The value to filter on

Declaration

public double Value { get; set; }

Property Value

Type	Description
Double