GrapeCity.Documents.Excel.IWorksheet.Sort

Sort Property

Sort

Gets the sort settings for the current worksheet.

Returns an ISort object that you can use to configure the sort range, sort fields, and sort orientation before calling Apply().

Declaration

ISort Sort { get; }

ReadOnly Property Sort As ISort

Examples

worksheet.Range["A1:A4"].Value = new object[,] {{5}, {3}, {4}, {2}};
ISort sort = worksheet.Sort;
sort.Range = worksheet.Range["A1:A4"];
sort.SortFields.Add(new ValueSortField(worksheet.Range["A1:A4"]));
sort.Apply();