Class TableSortLayer

Table sort layer

Inheritance

object

SortLayerBase

TableSortLayer

Inherited Members

SortLayerBase.SetColumn(int)

SortLayerBase.SetColumn(int, eSortOrder)

SortLayerBase.SetRow(int)

SortLayerBase.SetRow(int, eSortOrder)

object.Equals(object)

object.Equals(object, object)

object.GetHashCode()

object.GetType()

object.MemberwiseClone()

object.ReferenceEquals(object, object)

object.ToString()

Namespace: OfficeOpenXml.Sorting

Assembly: EPPlus.dll

Syntax

public class TableSortLayer : SortLayerBase

Methods

Column(int)

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

Declaration

public TableSortLayerBuilder Column(int column)

Parameters

Type	Name	Description
int	column	The column to sort

Returns

Type	Description
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.

Declaration

public TableSortLayerBuilder Column(int column, eSortOrder sortOrder)

Parameters

Type	Name	Description
int	column	The column to sort
eSortOrder	sortOrder	Ascending or Descending sort

Returns

Type	Description
TableSortLayerBuilder	A TableSortLayerBuilder for adding more sort criterias

ColumnNamed(string)

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

Declaration

public TableSortLayerBuilder ColumnNamed(string columnName)

Parameters

Type	Name	Description
string	columnName	The name of the column to sort, see Name.

Returns

Type	Description
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.

Declaration

public TableSortLayerBuilder ColumnNamed(string columnName, eSortOrder sortOrder)

Parameters

Type	Name	Description
string	columnName	Name of the column to sort, see Name
eSortOrder	sortOrder	Ascending or Descending sort

Returns

Type	Description
TableSortLayerBuilder	A TableSortLayerBuilder for adding more sort criterias