Sort Data in Spreadsheets

Aspose.Cells - Sort Data in Spreadsheets

To sort data in spreadsheets using Aspose.Cells, simply invoke the DataSorter.sorter() method after setting a few easy‑to‑set properties of the 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 cell 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.