java.lang.Objectcom.aspose.cells.DataSorter
public class DataSorter
Example:
//Instantiate a new Workbook object.
Workbook workbook = new Workbook("C:\\Book1.xls");
//Get the workbook datasorter object.
DataSorter sorter = workbook.getDataSorter();
//Set the first order for datasorter object.
sorter.setOrder1(com.aspose.cells.SortOrder.DESCENDING);
//Define the first key.
sorter.setKey1(0);
//Set the second order for datasorter object.
sorter.setOrder2(com.aspose.cells.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 = 0;
//Specify the start column index.
ca.StartColumn = 0;
//Specify the last row index.
ca.EndRow = 13;
//Specify the last column index.
ca.EndColumn = 1;
//Sort data in the specified data range (A1:B14)
sorter.sort(workbook.getWorksheets().get(0).getCells(), ca);
//Save the excel file.
workbook.save("C:\\outBook.xls");
Property Getters/Setters Summary | ||
---|---|---|
boolean | getCaseSensitive() | |
void | setCaseSensitive(boolean value) | |
Gets and sets whether case sensitive when comparing string. | ||
boolean | hasHeaders() | |
void | setHasHeaders(boolean value) | |
Represents whether the range has headers. | ||
int | getKey1() | |
void | setKey1(int value) | |
Represents first sorted column index. | ||
int | getKey2() | |
void | setKey2(int value) | |
Represents second sorted column index. | ||
int | getKey3() | |
void | setKey3(int value) | |
Represents third sorted column index. | ||
int | getOrder1() | |
void | setOrder1(int value) | |
Represents sort order of the first key. The value of the property is SortOrder integer constant. | ||
int | getOrder2() | |
void | setOrder2(int value) | |
Represents sort order of the second key. The value of the property is SortOrder integer constant. | ||
int | getOrder3() | |
void | setOrder3(int value) | |
Represents sort order of the third key. The value of the property is SortOrder integer constant. | ||
boolean | getSortLeftToRight() | |
void | setSortLeftToRight(boolean value) | |
True means that sorting orientation is from left to right. False means that sorting orientation is from top to bottom. The default value is false. |
Method Summary | ||
---|---|---|
void | addKey(int key, int order) | |
Adds sorted column index and sort order. | ||
void | clear() | |
Clear all settings. | ||
void | sort() | |
Sort the data in the range. | ||
void | sort(Cells cells, CellArea area) | |
Sort the datas of the area. | ||
void | sort(Cells cells, int startRow, int startColumn, int endRow, int endColumn) | |
Sorts the data of the area. |
Property Getters/Setters Detail |
---|
hasHeaders/setHasHeaders | |
public boolean hasHeaders() / public void setHasHeaders(boolean value) |
getKey1/setKey1 | |
public int getKey1() / public void setKey1(int value) |
getOrder1/setOrder1 | |
public int getOrder1() / public void setOrder1(int value) |
getKey2/setKey2 | |
public int getKey2() / public void setKey2(int value) |
getOrder2/setOrder2 | |
public int getOrder2() / public void setOrder2(int value) |
getKey3/setKey3 | |
public int getKey3() / public void setKey3(int value) |
getOrder3/setOrder3 | |
public int getOrder3() / public void setOrder3(int value) |
getSortLeftToRight/setSortLeftToRight | |
public boolean getSortLeftToRight() / public void setSortLeftToRight(boolean value) |
getCaseSensitive/setCaseSensitive | |
public boolean getCaseSensitive() / public void setCaseSensitive(boolean value) |
Method Detail |
---|
clear | |
public void clear() |
addKey | |
public void addKey(int key, int order) |
key
- The sorted column index.order
- A sort | |
public void sort(Cells cells, int startRow, int startColumn, int endRow, int endColumn) |
cells
- The cells contains the data area.startRow
- The start row of the area.startColumn
- The start column of the area.endRow
- The end row of the area.endColumn
- The end column of the area.sort | |
public void sort(Cells cells, CellArea area) |
cells
- The cells contains the data area.area
- The area needed to sortsort | |
public void sort() |