|
SfSpreadsheet provides support to sort a range of cells in the workbook based on data. Sorting can be done based on cell values, font color and cell color respectively. For more info, please go through XlsIO UG link
For sorting process,
The following code illustrates how to perform the sorting operation in SfSpreadsheet
C# IDataSort sorter = this.spreadsheet.Workbook.CreateDataSorter(); //To sort a range of cells, sorter.SortRange = this.spreadsheet.ActiveSheet.Range["E3:E8"]; sorter.HasHeader = false; ISortField sortField = sorter.SortFields.Add(4, SortOn.Values,OrderBy.Ascending); sorter.Sort(); sorter.SortFields.Remove(sortField); spreadsheet.ActiveGrid.InvalidateCell(GridRangeInfo.Cells(2,5,8,6), true); // To sort a particular column sorter.SortRange = this.spreadsheet.ActiveSheet. Range["C3:C12"]; sorter.HasHeader = false; ISortField sortField = sorter.SortFields.Add(2, SortOn.Values,OrderBy.Descending); sorter.Sort(); sorter.SortFields.Remove(sortField); spreadsheet.ActiveGrid.InvalidateCell(GridRangeInfo.Col(2), true);
Sample links:
|
2X faster development
The ultimate WPF UI toolkit to boost your development speed.
This page will automatically be redirected to the sign-in page in 10 seconds.
You are using an outdated version of Internet Explorer that may not display all features of this and other websites. Upgrade to Internet Explorer 8 or newer for a better experience.
