Table of Contents

Class SortColumn

Namespace
Spire.Xls.Core.Spreadsheet.Sorting
Assembly
Spire.XLS.dll
public class SortColumn : ISortColumn
Inheritance
SortColumn
Implements
Inherited Members

Constructors

SortColumn(SortColumns, int, SortComparsionType, OrderBy)

public SortColumn(SortColumns parent, int key, SortComparsionType sortComparsionType, OrderBy orderBy)

Parameters

parent SortColumns
key int
sortComparsionType SortComparsionType
orderBy OrderBy

SortColumn(SortColumns, int, string[])

public SortColumn(SortColumns parent, int key, string[] customSortOrder)

Parameters

parent SortColumns
key int
customSortOrder string[]

Properties

Color

Represents the color to sort. Throws exception when SortOn type is Values.

public Color Color { get; set; }

Property Value

Color

ComparsionType

Represents the sort by in the range.

public SortComparsionType ComparsionType { get; set; }

Property Value

SortComparsionType

CustomSortOrder

Represents the custom sort order data.

public string[] CustomSortOrder { get; set; }

Property Value

string[]

Key

Represents the column to be sorted on.

public int Key { get; set; }

Property Value

int

Order

Represents the sort order.

public OrderBy Order { get; set; }

Property Value

OrderBy

Methods

SetLevel(int)

public void SetLevel(int level)

Parameters

level int