Worksheet.Sort(CellRange, Fill, Boolean) Method

Sorts the specified range by the specified color in the specified order.

Namespace: DevExpress.Spreadsheet

Assembly: DevExpress.Spreadsheet.v24.1.Core.dll

NuGet Package: DevExpress.Spreadsheet.Core

Declaration

C#

void Sort(
    CellRange range,
    Fill fill,
    bool ascending
)

VB.NET

Sub Sort(
    range As CellRange,
    fill As Fill,
    ascending As Boolean
)

Parameters

Name	Type	Description
range	CellRange	The range of worksheet cells.
fill	Fill	An object that contains the fill parameters.
ascending	Boolean	true to specify ascending order; otherwise, false.

Remarks

Example

The following code sample sorts the cell range by background color in descending order:

C#

using DevExpress.Spreadsheet;
using System.Diagnostics;

using (var workbook = new Workbook()) {
    workbook.LoadDocument("Document.xlsx");
    Worksheet worksheet = workbook.Worksheets["SortSample"];
    workbook.Worksheets.ActiveWorksheet = worksheet;

    CellRange range = worksheet.Range["A3:F22"];
    Fill fillSettings = worksheet["A3"].Fill;
    worksheet.Sort(range, fillSettings, false);
    workbook.SaveDocument("result.xlsx", DocumentFormat.Xlsx);
    Process.Start(new ProcessStartInfo("result.xlsx") { UseShellExecute = true });
}

VB.NET

Imports DevExpress.Spreadsheet
Imports System.Diagnostics

Using workbook = New Workbook()
  workbook.LoadDocument("Document.xlsx")
  Dim worksheet As Worksheet = workbook.Worksheets("SortSample")
  workbook.Worksheets.ActiveWorksheet = worksheet

  Dim range As CellRange = worksheet.Range("A3:F22")
  Dim fillSettings As Fill = worksheet("A3").Fill
  worksheet.Sort(range, fillSettings, false)
  workbook.SaveDocument("result.xlsx", DocumentFormat.Xlsx)
  Process.Start(New ProcessStartInfo("result.xlsx") With {.UseShellExecute = True})
End Using