AsposeDataSort.java

package com.aspose.cells.examples.asposefeatures.datahandling.sortdata;

import com.aspose.cells.CellArea;
import com.aspose.cells.Cells;
import com.aspose.cells.DataSorter;
import com.aspose.cells.SortOrder;
import com.aspose.cells.Workbook;
import com.aspose.cells.Worksheet;
import com.aspose.cells.examples.Utils;

public class AsposeDataSort
{
    public static void main(String[] args) throws Exception
    {
        // The path to the documents directory.
        String dataDir = Utils.getDataDir(AsposeDataSort.class);

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