Class TableSortLayer

Namespace

OfficeOpenXml.Sorting

Assembly

EPPlus.dll

Table sort layer

public class TableSortLayer : SortLayerBase

Inheritance

object

SortLayerBase

TableSortLayer

Inherited Members

SortLayerBase.SetColumn(int)

SortLayerBase.SetColumn(int, eSortOrder)

SortLayerBase.SetRow(int)

SortLayerBase.SetRow(int, eSortOrder)

object.GetType()

object.MemberwiseClone()

object.ToString()

object.Equals(object)

object.Equals(object, object)

object.ReferenceEquals(object, object)

object.GetHashCode()

Methods

Column(int)

Sorts by the column that corresponds to the column (zerobased) with ascending sort direction

public TableSortLayerBuilder Column(int column)

Parameters

column int

The column to sort

Returns

TableSortLayerBuilder

A TableSortLayerBuilder for adding more sort criterias

Column(int, eSortOrder)

Sorts by the column that corresponds to the column (zerobased) using the supplied sort direction.

public TableSortLayerBuilder Column(int column, eSortOrder sortOrder)

Parameters

column int

The column to sort

sortOrder eSortOrder

Ascending or Descending sort

Returns

TableSortLayerBuilder

A TableSortLayerBuilder for adding more sort criterias

ColumnNamed(string)

Sorts by the column that corresponds to the columnName ith ascending sort direction

public TableSortLayerBuilder ColumnNamed(string columnName)

Parameters

columnName string

The name of the column to sort, see Name.

Returns

TableSortLayerBuilder

A TableSortLayerBuilder for adding more sort criterias

ColumnNamed(string, eSortOrder)

Sorts by the column that corresponds to the columnName using the supplied sort direction.

public TableSortLayerBuilder ColumnNamed(string columnName, eSortOrder sortOrder)

Parameters

columnName string

Name of the column to sort, see Name

sortOrder eSortOrder

Ascending or Descending sort

Returns

TableSortLayerBuilder

A TableSortLayerBuilder for adding more sort criterias