Sort Excel Data Using Java

Data sorting in Excel is to sort one or more columns of unordered data according to different needs, which helps to display the data in a more organized way and also helps people find the required data faster. This article will demonstrate how to sort data within a cell range using Free Spire.XLS for Java.

Method 1: Download the free Java library and unzip it, then add the Spire.Xls.jar file to your project as dependency.

Method 2: You can also add the jar dependency to maven project by adding the following configurations to the pom.xml.


Sample Code

import com.spire.xls.*;

public class SortData {

public static void main(String[] args) {

//Create a Workbook object
Workbook workbook = new Workbook();

//Load the sample Excel file

//Get the first worksheet
Worksheet sheet = workbook.getWorksheets().get(0);

//Specify the column index and the sort mode. The column index starts from 0.
workbook.getDataSorter().getSortColumns().add(0, SortComparsionType.Values, OrderBy.Ascending);

//Specify the range to sort

//Save the document
workbook.saveToFile("SortData.xlsx", ExcelVersion.Version2013);


Sharing Java Code