在 C# 中排序 Excel 範圍
在 Microsoft Excel 中按字母或數值順序排列數據可使數據的人工分析變得可行。IronXL 使在 C# 和 VB.NET 中對 Excel 列、行和範圍進行排序變得極其簡單。
使用 SortAscending 或 SortDescending 方法在選定的範圍或列上應用相應的排序順序。然而，SortByColumn 方法需要兩個參數。第一個參數是要排序的列，第二個參數是排序順序。
using IronXL;
WorkBook workBook = WorkBook.Load("sample.xlsx");
WorkSheet workSheet = workBook.DefaultWorkSheet;
// Select a range
var range = workSheet["A1:D20"];
// Select a column(B)
var column = workSheet.GetColumn(1);
// Sort the range in ascending order (A to Z)
range.SortAscending();
// Sort the range by column(C) in ascending order
range.SortByColumn("C", SortOrder.Ascending);
// Sort the column(B) in descending order (Z to A)
column.SortDescending();
workBook.SaveAs("sortExcelRange.xlsx");Imports IronXL
Private workBook As WorkBook = WorkBook.Load("sample.xlsx")
Private workSheet As WorkSheet = workBook.DefaultWorkSheet
' Select a range
Private range = workSheet("A1:D20")
' Select a column(B)
Private column = workSheet.GetColumn(1)
' Sort the range in ascending order (A to Z)
range.SortAscending()
' Sort the range by column(C) in ascending order
range.SortByColumn("C", SortOrder.Ascending)
' Sort the column(B) in descending order (Z to A)
column.SortDescending()
workBook.SaveAs("sortExcelRange.xlsx")
