Enum SortOrder

SortOrder enumeration

Represents sort order for the data range.

public enum SortOrder

Values

NameValueDescription
Ascending0Sorts data in ascending order
Descending1Sorts data in descending order
Natural2Keeps original data order without sorting. Only applies to some special scenarios such as PivotTable.

Examples

using System;
using Aspose.Cells;

namespace AsposeCellsExamples
{
    public class CellsClassSortOrderDemo
    {
        public static void Run()
        {
            // Create a new workbook
            var workbook = new Workbook();
            
            // Access the first worksheet
            Worksheet worksheet = workbook.Worksheets[0];
            
            // Add sample data to sort
            worksheet.Cells["A1"].PutValue("Name");
            worksheet.Cells["B1"].PutValue("Score");
            worksheet.Cells["A2"].PutValue("John");
            worksheet.Cells["B2"].PutValue(85);
            worksheet.Cells["A3"].PutValue("Alice");
            worksheet.Cells["B3"].PutValue(92);
            worksheet.Cells["A4"].PutValue("Bob");
            worksheet.Cells["B4"].PutValue(78);
            
            // Create data sorter
            var sorter = workbook.DataSorter;
            
            // Set sort order and keys
            sorter.Order1 = SortOrder.Descending;
            sorter.Key1 = 1; // Sort by column B (Score)
            
            // Define sort area
            var sortArea = new CellArea
            {
                StartRow = 0,
                StartColumn = 0,
                EndRow = 3,
                EndColumn = 1
            };
            
            // Perform the sort
            sorter.Sort(worksheet.Cells, sortArea);
            
            // Save the workbook
            workbook.Save("SortedData.xlsx");
        }
    }
}

See Also