Interface IXLFilterColumn

Namespace

SlapKit.Excel.Excel

Assembly

SlapKit.Excel.dll

public interface IXLFilterColumn

Extension Methods

AttributeExtensions.GetMethod<T>(T, Expression<Action<T>>)

AttributeExtensions.GetMethod<T>(T, Expression<Func<T, object>>)

Properties

ColorFilterType

XLFilterColorType ColorFilterType { get; }

Property Value

XLFilterColorType

DynamicType

XLFilterDynamicType DynamicType { get; set; }

Property Value

XLFilterDynamicType

DynamicValue

double DynamicValue { get; set; }

Property Value

double

FilterType

XLFilterType FilterType { get; set; }

Property Value

XLFilterType

TopBottomPart

XLTopBottomPart TopBottomPart { get; set; }

Property Value

XLTopBottomPart

TopBottomType

XLTopBottomType TopBottomType { get; set; }

Property Value

XLTopBottomType

TopBottomValue

int TopBottomValue { get; set; }

Property Value

int

Methods

AboveAverage()

void AboveAverage()

AddDateGroupFilter(DateTime, XLDateTimeGrouping)

IXLFilteredColumn AddDateGroupFilter(DateTime date, XLDateTimeGrouping dateTimeGrouping)

Parameters

date DateTime

dateTimeGrouping XLDateTimeGrouping

Returns

IXLFilteredColumn

AddFilter<T>(T)

IXLFilteredColumn AddFilter<T>(T value) where T : IComparable<T>

Parameters

value T

Returns

IXLFilteredColumn

Type Parameters

T

April()

void April()

August()

void August()

BeginsWith(string)

IXLFilterConnector BeginsWith(string value)

Parameters

value string

Returns

IXLFilterConnector

BelowAverage()

void BelowAverage()

Between<T>(T, T)

void Between<T>(T minValue, T maxValue) where T : IComparable<T>

Parameters

minValue T

maxValue T

Type Parameters

T

Bottom(int, XLTopBottomType)

void Bottom(int value, XLTopBottomType type = XLTopBottomType.Items)

Parameters

value int

type XLTopBottomType

CellColor(IXLFill)

void CellColor(IXLFill fill)

Parameters

fill IXLFill

CellColor(Action<IXLFill>?)

void CellColor(Action<IXLFill>? setter = null)

Parameters

setter Action<IXLFill>

Clear()

void Clear()

Contains(string)

IXLFilterConnector Contains(string value)

Parameters

value string

Returns

IXLFilterConnector

December()

void December()

EndsWith(string)

IXLFilterConnector EndsWith(string value)

Parameters

value string

Returns

IXLFilterConnector

EqualOrGreaterThan<T>(T)

IXLFilterConnector EqualOrGreaterThan<T>(T value) where T : IComparable<T>

Parameters

value T

Returns

IXLFilterConnector

Type Parameters

T

EqualOrLessThan<T>(T)

IXLFilterConnector EqualOrLessThan<T>(T value) where T : IComparable<T>

Parameters

value T

Returns

IXLFilterConnector

Type Parameters

T

EqualTo<T>(T)

IXLFilterConnector EqualTo<T>(T value) where T : IComparable<T>

Parameters

value T

Returns

IXLFilterConnector

Type Parameters

T

February()

void February()

FontColor(XLColor)

void FontColor(XLColor color)

Parameters

color XLColor

GreaterThan<T>(T)

IXLFilterConnector GreaterThan<T>(T value) where T : IComparable<T>

Parameters

value T

Returns

IXLFilterConnector

Type Parameters

T

January()

void January()

July()

void July()

June()

void June()

LastMonth()

void LastMonth()

LastQuarter()

void LastQuarter()

LastWeek()

void LastWeek()

LastYear()

void LastYear()

LessThan<T>(T)

IXLFilterConnector LessThan<T>(T value) where T : IComparable<T>

Parameters

value T

Returns

IXLFilterConnector

Type Parameters

T

March()

void March()

May()

void May()

NextMonth()

void NextMonth()

NextQuarter()

void NextQuarter()

NextWeek()

void NextWeek()

NextYear()

void NextYear()

NotBeginsWith(string)

IXLFilterConnector NotBeginsWith(string value)

Parameters

value string

Returns

IXLFilterConnector

NotBetween<T>(T, T)

void NotBetween<T>(T minValue, T maxValue) where T : IComparable<T>

Parameters

minValue T

maxValue T

Type Parameters

T

NotContains(string)

IXLFilterConnector NotContains(string value)

Parameters

value string

Returns

IXLFilterConnector

NotEndsWith(string)

IXLFilterConnector NotEndsWith(string value)

Parameters

value string

Returns

IXLFilterConnector

NotEqualTo<T>(T)

IXLFilterConnector NotEqualTo<T>(T value) where T : IComparable<T>

Parameters

value T

Returns

IXLFilterConnector

Type Parameters

T

November()

void November()

October()

void October()

Quarter1()

void Quarter1()

Quarter2()

void Quarter2()

Quarter3()

void Quarter3()

Quarter4()

void Quarter4()

RemoveBlankFilter()

IXLFilteredColumn RemoveBlankFilter()

Returns

IXLFilteredColumn

September()

void September()

SetBlankFilter()

IXLFilteredColumn SetBlankFilter()

Returns

IXLFilteredColumn

SetDynamicType(XLFilterDynamicType)

IXLFilterColumn SetDynamicType(XLFilterDynamicType value)

Parameters

value XLFilterDynamicType

Returns

IXLFilterColumn

SetDynamicValue(double)

IXLFilterColumn SetDynamicValue(double value)

Parameters

value double

Returns

IXLFilterColumn

SetFilterType(XLFilterType)

IXLFilterColumn SetFilterType(XLFilterType value)

Parameters

value XLFilterType

Returns

IXLFilterColumn

SetTopBottomPart(XLTopBottomPart)

IXLFilterColumn SetTopBottomPart(XLTopBottomPart value)

Parameters

value XLTopBottomPart

Returns

IXLFilterColumn

SetTopBottomType(XLTopBottomType)

IXLFilterColumn SetTopBottomType(XLTopBottomType value)

Parameters

value XLTopBottomType

Returns

IXLFilterColumn

SetTopBottomValue(int)

IXLFilterColumn SetTopBottomValue(int value)

Parameters

value int

Returns

IXLFilterColumn

ThisMonth()

void ThisMonth()

ThisQuarter()

void ThisQuarter()

ThisWeek()

void ThisWeek()

ThisYear()

void ThisYear()

Today()

void Today()

Tomorrow()

void Tomorrow()

Top(int, XLTopBottomType)

void Top(int value, XLTopBottomType type = XLTopBottomType.Items)

Parameters

value int

type XLTopBottomType

YearToDate()

void YearToDate()

Yesterday()

void Yesterday()