CellArea

CellArea class

Represent an area of cells.

Example

const { CellArea } = require("aspose.cells.node");

//Create Cell Area
var ca = new CellArea();
ca.startRow = 0;
ca.endRow = 0;
ca.startColumn = 0;
ca.endColumn = 0;

Constructors

NameDescription
constructor()Default Constructor.

Properties

NameDescription
startRowGets or sets the start row of this area.
endRowGets or sets the end row of this area.
startColumnGets or sets the start column of this area.
endColumnGets or sets the end column of this area.

Methods

MethodDescription
toString()Returns a string represents the current cell area object.
static createCellArea(number, number, number, number)Creates a cell area.
static createCellArea(string, string)Creates a cell area.

constructor()

Default Constructor.

constructor();

toString()

Returns a string represents the current cell area object.

toString() : string;

createCellArea(number, number, number, number)

Creates a cell area.

static createCellArea(startRow: number, startColumn: number, endRow: number, endColumn: number) : CellArea;

Parameters:

ParameterTypeDescription
startRownumberThe start row.
startColumnnumberThe start column.
endRownumberThe end row.
endColumnnumberThe end column.

Returns

CellArea

createCellArea(string, string)

Creates a cell area.

static createCellArea(startCellName: string, endCellName: string) : CellArea;

Parameters:

ParameterTypeDescription
startCellNamestringThe top-left cell of the range.
endCellNamestringThe bottom-right cell of the range.

Returns

CellArea