Workbook.DataSorter
Workbook.DataSorter property
Gets a DataSorter object to sort data.
public DataSorter DataSorter { get; }
Examples
using System;
using Aspose.Cells;
namespace AsposeCellsExamples
{
public class WorkbookPropertyDataSorterDemo
{
public static void Run()
{
// Create a workbook with sample data
Workbook wb = new Workbook();
Worksheet ws = wb.Worksheets[0];
// Add sample data
ws.Cells["A1"].PutValue("Name");
ws.Cells["B1"].PutValue("Age");
ws.Cells["C1"].PutValue("Score");
ws.Cells["A2"].PutValue("John");
ws.Cells["B2"].PutValue(25);
ws.Cells["C2"].PutValue(85);
ws.Cells["A3"].PutValue("Alice");
ws.Cells["B3"].PutValue(30);
ws.Cells["C3"].PutValue(92);
ws.Cells["A4"].PutValue("Bob");
ws.Cells["B4"].PutValue(22);
ws.Cells["C4"].PutValue(78);
// Configure DataSorter
wb.DataSorter.Order1 = SortOrder.Ascending;
wb.DataSorter.Key1 = ws.Cells["C1"].Column; // Sort by Score
// Define sort range
CellArea area = new CellArea();
area.StartRow = 0;
area.EndRow = 4;
area.StartColumn = 0;
area.EndColumn = 2;
// Perform the sort
wb.DataSorter.Sort(ws.Cells, area);
// Output the sorted data
Console.WriteLine("Sorted Data:");
for (int row = 0; row <= 4; row++)
{
Console.WriteLine($"{ws.Cells[row, 0].StringValue}, {ws.Cells[row, 1].IntValue}, {ws.Cells[row, 2].IntValue}");
}
}
}
}
See Also
- class DataSorter
- class Workbook
- namespace Aspose.Cells
- assembly Aspose.Cells