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

ConstructorDescription
constructor()Default Constructor.

Properties

PropertyTypeDescription
startRownumberGets or sets the start row of this area.
endRownumberGets or sets the end row of this area.
startColumnnumberGets or sets the start column of this area.
endColumnnumberGets 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