Skip to main content
All docs
V25.1
  • Row

    Worksheet.Sort(CellRange, Fill, Boolean) Method

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

    Namespace: DevExpress.Spreadsheet

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

    NuGet Package: DevExpress.Spreadsheet.Core

    Declaration

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

    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:

    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 });
    }
    
    See Also