aspose.cells
Class Name

//Instantiating a Workbook object
$workbook = new cells\Workbook();
//Accessing the first worksheet in the Excel file
$worksheet = $workbook->getWorksheets()->get(0);
//Creating a named range
$range = $worksheet->getCells()->createRange("B4", "G14");
//Setting the name of the named range
$range->setName("TestRange");

function getComment() / function setComment(value)

Gets and sets the commont of the name. Only applies for Excel 2007.

function getText() / function setText(value)

Gets the name text of the object.

function getFullText()

Gets the name full text of the object with the scope setting.

function getRefersTo() / function setRefersTo(value)

Returns or sets the formula that the name is defined to refer to, beginning with an equal sign.

function getR1C1RefersTo() / function setR1C1RefersTo(value)

Gets or sets a R1C1 reference of the Name.

function isReferred()

Indicates whether this name is referred by other formulas.

function isVisible() / function setVisible(value)

Indicates whether the name is visible.

function getSheetIndex() / function setSheetIndex(value)

Indicates this name belongs to Workbook or Worksheet. 0 = Global name, otherwise index to sheet (one-based)

function getRefersTo(isR1C1, isLocal)

Get the reference of this Name.

Parameters:

isR1C1: boolean - Whether the reference needs to be formatted as R1C1.

isLocal: boolean - Whether the reference needs to be formatted by locale.

function setRefersTo(refersTo, isR1C1, isLocal)

Set the reference of this Name.

Parameters:

refersTo: String - The reference.

isR1C1: boolean - Whether the reference is R1C1 format.

isLocal: boolean - Whether the reference is locale formatted.

function toString()

Returns a string represents the current Range object.

Returns:

function getRanges()

Gets all ranges referred by this name.

Returns:

All ranges.

function getRanges(recalculate)

Gets all ranges referred by this name.

Parameters:

recalculate: boolean - whether recalcuate it if this name has been calcualted before this invocation.

Returns:

All ranges.

function getReferredAreas(recalculate)

Gets all references referred by this name.

Parameters:

recalculate: boolean - whether recalcuate it if this name has been calcualted before this invocation.

Returns:

All ranges.

function getRange()

Gets the range if this name refers to a range.

Returns:

The range.

function getRange(recalculate)

Gets the range if this name refers to a range

Parameters:

recalculate: boolean - whether recalcuate it if this name has been calcualted before this invocation.

Returns:

The range.

function getRange(sheetIndex, row, column)

Gets the range if this name refers to a range. If the reference of this name is not absolute, the range may be different for different cell.

Parameters:

sheetIndex: Number - The according sheet index.

row: Number - The according row index.

column: Number - The according column index

Returns:

The range.