Interface IXLAutoFilter

Namespace

SlapKit.Excel.Excel

Assembly

SlapKit.Excel.dll

public interface IXLAutoFilter

Extension Methods

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

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

Properties

HiddenRows

IEnumerable<IXLRangeRow> HiddenRows { get; }

Property Value

IEnumerable<IXLRangeRow>

IsEnabled

bool IsEnabled { get; set; }

Property Value

bool

Range

IXLRange Range { get; set; }

Property Value

IXLRange

SortColumn

int SortColumn { get; set; }

Property Value

int

SortOrder

XLSortOrder SortOrder { get; set; }

Property Value

XLSortOrder

Sorted

bool Sorted { get; set; }

Property Value

bool

VisibleRows

IEnumerable<IXLRangeRow> VisibleRows { get; }

Property Value

IEnumerable<IXLRangeRow>

Methods

Clear()

IXLAutoFilter Clear()

Returns

IXLAutoFilter

Column(int)

IXLFilterColumn Column(int column)

Parameters

column int

Returns

IXLFilterColumn

Column(string)

IXLFilterColumn Column(string column)

Parameters

column string

Returns

IXLFilterColumn

Reapply()

IXLAutoFilter Reapply()

Returns

IXLAutoFilter

Sort(int, XLSortOrder, bool, bool)

IXLAutoFilter Sort(int columnToSortBy = 1, XLSortOrder sortOrder = XLSortOrder.Ascending, bool matchCase = false, bool ignoreBlanks = true)

Parameters

columnToSortBy int

sortOrder XLSortOrder

matchCase bool

ignoreBlanks bool

Returns

IXLAutoFilter