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 

static

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.

static

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.