Sort Excel Ranges in C#

VB C#

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")

Install-Package IronXL.Excel

Sort Excel Ranges in C#

Arranging data in alphabetical or value order makes human analysis of data feasible in Microsoft Excel. IronXL makes sorting Excel Columns, Rows, and Ranges extremely simple in C# and VB.NET.

Use the SortAscending or SortDescending methods on the selected range or column to apply sorting in the appropriate order. The SortByColumn method, however, requires two parameters: The first input is the column intended to be sorted and the second input is the sorting order.

Here is an example of how you can sort data using C#:

using IronXL; class ExcelSorter { static void Main(string[] args) { // Load the Excel file WorkBook workbook = WorkBook.Load("example.xlsx"); // Select the first worksheet WorkSheet sheet = workbook.WorkSheets.First(); // To sort the entire sheet in ascending order based on the first column sheet.SortAscending(sheet["A"]); // Alternatively, sort a specific range in descending order sheet.SortDescending(sheet["A2:A10"]); // Using SortByColumn method to sort by specific column in ascending order sheet.SortByColumn("B", ExcelSortOrder.Ascending); // Save the modified workbook workbook.SaveAs("sorted_example.xlsx"); } }

using IronXL; class ExcelSorter { static void Main(string[] args) { // Load the Excel file WorkBook workbook = WorkBook.Load("example.xlsx"); // Select the first worksheet WorkSheet sheet = workbook.WorkSheets.First(); // To sort the entire sheet in ascending order based on the first column sheet.SortAscending(sheet["A"]); // Alternatively, sort a specific range in descending order sheet.SortDescending(sheet["A2:A10"]); // Using SortByColumn method to sort by specific column in ascending order sheet.SortByColumn("B", ExcelSortOrder.Ascending); // Save the modified workbook workbook.SaveAs("sorted_example.xlsx"); } }

Imports IronXL Friend Class ExcelSorter	Shared Sub Main(ByVal args() As String)	' Load the Excel file	Dim workbook As WorkBook = WorkBook.Load("example.xlsx")	' Select the first worksheet	Dim sheet As WorkSheet = workbook.WorkSheets.First()	' To sort the entire sheet in ascending order based on the first column	sheet.SortAscending(sheet("A"))	' Alternatively, sort a specific range in descending order	sheet.SortDescending(sheet("A2:A10"))	' Using SortByColumn method to sort by specific column in ascending order	sheet.SortByColumn("B", ExcelSortOrder.Ascending)	' Save the modified workbook	workbook.SaveAs("sorted_example.xlsx")	End Sub End Class

$vbLabelText $csharpLabel

Explanation:

Loading the workbook: First, we load an existing Excel file using WorkBook.Load("example.xlsx").
Selecting a worksheet: The line WorkSheet sheet = workbook.WorkSheets.First() selects the first worksheet in the Excel file.
Sorting the entire sheet: sheet.SortAscending(sheet["A"]); sorts data in the entire sheet based on column A in ascending order.
Sorting a specific range: sheet.SortDescending(sheet["A2:A10"]); sorts data within the range A2 to A10 in descending order.
Sorting by column: The SortByColumn method sorts data by a specific column, allowing you to specify the sort order (ascending or descending). In this example, we sort column B in ascending order.
Saving the workbook: Lastly, the modified workbook is saved using workbook.SaveAs("sorted_example.xlsx").