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