Sort Data in xlsx4j

Aspose.Cells - Sort Data

To sort data in a spreadsheet using Aspose.Cells, simply invoke the DataSorter.sort() method after setting a few easy‑to‑set properties of the cell area.
Java code is mentioned below:

Java

 //Instantiating a Workbook object
Workbook workbook = new Workbook(dataDir + "AsposeDataInput.xls");

//Accessing the first worksheet in the Excel file
Worksheet worksheet = workbook.getWorksheets().get(0);

//Get the cells collection in the sheet
Cells cells = worksheet.getCells();

//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);

//Saving the Excel file
workbook.save(dataDir + "AsposeSortedData_Out.xls");

Download Running Code

• GitHub

Download Sample Code

• GitHub

For more details, visit Sort Data or Data Sorting.