SortData.java

package com.aspose.cells.examples.articles;

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 SortData {
	public static void main(String[] args) throws Exception {

		String dataDir = Utils.getSharedDataDir(SortData.class) + "articles/";

		// Instantiating a Workbook object
		Workbook workbook = new Workbook(dataDir + "Book_SourceData.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 + "SortData_out.xls");


	}
}