Worksheet.Sort(CellRange, Fill) Method

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

Assembly : DevExpress.Spreadsheet.v25.2.Core.dll

NuGet Package : DevExpress.Spreadsheet.Core

Declaration

C#
VB.NET

csharp

void Sort(
    CellRange range,
    Fill fill
)

Sub Sort(
    range As CellRange,
    fill As Fill
)

Parameters

Name	Type	Description
range	CellRange

The range of worksheet cells.

| | fill | Fill |

An object that contains the fill parameters.

Remarks

Example

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

C#
VB.NET

csharp

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);
    workbook.SaveDocument("result.xlsx", DocumentFormat.Xlsx);
    Process.Start(new ProcessStartInfo("result.xlsx") { UseShellExecute = true });
}

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)
  workbook.SaveDocument("result.xlsx", DocumentFormat.Xlsx)
  Process.Start(New ProcessStartInfo("result.xlsx") With {.UseShellExecute = True})
End Using