Sort Data in Spreadsheets

Aspose.Cells - Sort Data in Spreadsheets

To sort data in spreadsheet using Aspose.Cells, simply invoke the DataSorter.sorter() method after setting few easy to set properties of cell area.

Java code is mentioned below.

Sort Data using Aspose.Cells

Java

 //Obtain the DataSorter object in the workbook

DataSorter sorter = workbook.getDataSorter();

//Set the first order

sorter.setOrder1(SortOrder.ASCENDING);

//Define the first key.

sorter.setKey1(0);

//Set the second order

sorter.setOrder2(SortOrder.ASCENDING);

//Define the second key

sorter.setKey2(1);

//Create a cells area (range).

CellArea ca = new CellArea();

//Specify the start row index.

ca.StartRow = 1;

//Specify the start column index.

ca.StartColumn = 0;

//Specify the last row index.

ca.EndRow = 9;

//Specify the last column index.

ca.EndColumn = 2;

//Sort data in the specified data range (A2:C10)

sorter.sort(cells, ca);

Download Running Code

• GitHub

Download Sample Code

• GitHub

For more details, visit Sort Data, or Data Sorting.