Sort Cells

Sorting a range of cell data is a commonly-used feature. To sort cells with Range is quite easy like:

1
2
3
4
5
//true for descending order, false for ascending
range.sort(true);

//use CellOperationUtil, it checks sheet protection before sorting
CellOperationUtil.sort(range, true);

When sorting a range of texts and numbers In ascending order, numbers will be arranged before text.

A range of cells before sorting:

A range of cells after sorting in ascending order:

Comments