Sort data

The following example shows you how to set a sort state on a worksheet so that the data is sorted when the file is opened in Excel.

import com.independentsoft.office.spreadsheet.Cell;
import com.independentsoft.office.spreadsheet.SortCondition;
import com.independentsoft.office.spreadsheet.SortState;
import com.independentsoft.office.spreadsheet.Workbook;
import com.independentsoft.office.spreadsheet.Worksheet;

public class Example {

    public static void main(String[] args)
    {
        try
        {
            Worksheet sheet = new Worksheet();
            sheet.setName("Data");

            sheet.set("A1", new Cell("Name"));
            sheet.set("B1", new Cell("Score"));
            sheet.set("A2", new Cell("Charlie"));
            sheet.set("B2", new Cell(85));
            sheet.set("A3", new Cell("Alice"));
            sheet.set("B3", new Cell(92));
            sheet.set("A4", new Cell("Bob"));
            sheet.set("B4", new Cell(78));
            sheet.set("A5", new Cell("Diana"));
            sheet.set("B5", new Cell(88));

            SortCondition condition = new SortCondition();
            condition.setReference("A1");
            condition.setDescending(false);

            SortState sortState = new SortState();
            sortState.setSortRange("A1:B5");
            sortState.setCondition(condition);

            sheet.setSortState(sortState);

            Workbook book = new Workbook();
            book.getSheets().add(sheet);
            book.save("c:\\test\\output.xlsx", true);
        }
        catch (Exception e)
        {
            System.out.println(e.getMessage());
            e.printStackTrace();
        }
    }
}

IndependentsoftProfessional software libraries for developers

JSpreadsheet > Tutorial > Sort data

Need help? Ask our developers: