How to: Programmatically Sort Data in Worksheets
You can sort data that is contained in worksheet ranges and lists at run time. The following code sorts a multi-column range named Fruits by the data in the first column, and then by the data in the second column.
Applies to: The information in this topic applies to document-level projects and VSTO add-in projects for Excel. For more information, see Features Available by Office Application and Project Type.
To sort data in a NamedRange control
Call the Sort method of the NamedRange control. The following example requires a NamedRange control named
Fruitson a worksheet. This code must be placed in a sheet class, not in theThisWorkbookclass.
Place the following code in Sheet1.vb or Sheet1.cs to sort data in a ListObject control. The code assumes that you have a Microsoft.Office.Tools.Excel.ListObject control named fruitList in a worksheet named Sheet1.
To sort data in a ListObject control
Call the Sort method of the Range property of the ListObject host control.
To sort data in a native range
Call the Sort method of the native Excel Microsoft.Office.Interop.Excel.Range control. The following example requires a native Excel control named
Fruitson a worksheet.
To sort data in a ListObject control
Call the Sort method of the Range property of the native Excel Microsoft.Office.Interop.Excel.ListObject control. The following example assumes that you have a native Excel Microsoft.Office.Interop.Excel.ListObject control named
fruitListin the active worksheet.
Working with Worksheets
How to: Programmatically Automatically Fill Ranges with Incrementally Changing Data
How to: Programmatically Refer to Worksheet Ranges in Code
How to: Programmatically Apply Styles to Ranges in Workbooks
NamedRange Control
ListObject Control
Optional Parameters in Office Solutions