Sort Excel Ranges in C#

Name: C# Excel Library - IronXL
Rating: 4.81 (173 reviews)

VB C#

using IronXL;

WorkBook workbook = WorkBook.Load("test.xlsx");
WorkSheet worksheet = workbook.DefaultWorkSheet;

//Select a Range
Range range = worksheet["A1:D20"];

//This is how we can sort the current range in ascending order (A to Z)
range.SortAscending();


//This is how we can sort the current range in descending order (Z to A)
range.SortDescending();

workbook.SaveAs("SortExcelRange.xlsx");

Imports IronXL

Private workbook As WorkBook = WorkBook.Load("test.xlsx")
Private worksheet As WorkSheet = workbook.DefaultWorkSheet

'Select a Range
Private range As Range = worksheet("A1:D20")

'This is how we can sort the current range in ascending order (A to Z)
range.SortAscending()


'This is how we can sort the current range in descending order (Z to A)
range.SortDescending()

workbook.SaveAs("SortExcelRange.xlsx")

Install-Package IronXL.Excel

Sort Excel Ranges in C#

IronXL makes sorting Excel Columns, Rows and Ranges extremely simple in C# and Vb.NET.

Arranging data in alphabetical or value order makes human analysis of data feasible in Microsoft Excel.

You can download the software product from this link.

Previous Example

Next Example

Ready to get started? Version: 2022.6 just released

View Licenses >