CellArea
Source: aspose.
Represent an area of cells.
Properties
new CellArea()
Example
//Create Cell Area
var ca = new aspose.cells.CellArea();
ca.StartRow = 0;
ca.EndRow = 0;
ca.StartColumn = 0;
ca.EndColumn = 0;
Properties
EndColumn
Gets or set the end column of this area.
EndRow
Gets or set the end row of this area.
StartColumn
Gets or set the start column of this area.
StartRow
Gets or set the start row of this area.
Methods
compareTo(obj) → Number
Compare two CellArea objects according to their top-left corner.
Parameter
Name | Type | Optional | Description |
---|---|---|---|
obj |
Object |
|
- Returns
-
Number
If two corners are in different rows, then compare their row index. Otherwise compare their column index. If two corners are same, then 0 will be returned.
toString() → String
Returns a string represents the current cell area object.
- Returns
-
String
createCellArea(startRow, startColumn, endRow, endColumn) → CellArea
Creates a cell area.
Parameters
Name | Type | Optional | Description |
---|---|---|---|
startRow |
Number |
|
The start row. |
startColumn |
Number |
|
The start column. |
endRow |
Number |
|
The end row. |
endColumn |
Number |
|
The end column. |
- Returns
-
CellArea
Return a CellArea.
createCellArea(startCellName, endCellName) → CellArea
Creates a cell area.
Parameters
Name | Type | Optional | Description |
---|---|---|---|
startCellName |
String |
|
The top-left cell of the range. |
endCellName |
String |
|
The bottom-right cell of the range. |
- Returns
-
CellArea
Return a CellArea.