GrapeCity.Documents.Excel.ITable.Sort

Sort Property

Sort

Gets the sort settings for this ITable.

The returned ISort object provides access to the sort fields and sort order applied to the table data. After configuring the sort fields, call Apply() to sort the table.

Declaration

ISort Sort { get; }

ReadOnly Property Sort As ISort

Examples

worksheet.Range["A1:B4"].Value = new object[,] {
    {"Name", "Score"},
    {"Tom", 80},
    {"Nancy", 95},
    {"Jack", 88}
};
ITable table = worksheet.Tables.Add(worksheet.Range["A1:B4"], true);
ISort sort = table.Sort;
sort.SortFields.Add(new ValueSortField(worksheet.Range["B2:B4"], SortOrder.Descending));
sort.Apply();