\PHPExcel_NamedRange

PHPExcel_NamedRange

Summary

Methods
Properties
Constants
__construct()
getName()
setName()
getWorksheet()
setWorksheet()
getRange()
setRange()
getLocalOnly()
setLocalOnly()
getScope()
setScope()
resolveRange()
__clone()
No public properties found
No constants found
No protected methods found
No protected properties found
N/A
No private methods found
$_name
$_worksheet
$_range
$_localOnly
$_scope
N/A

Properties

$_name

$_name : string

Range name

Type

string

$_worksheet

$_worksheet : \PHPExcel_Worksheet

Worksheet on which the named range can be resolved

Type

\PHPExcel_Worksheet

$_range

$_range : string

Range of the referenced cells

Type

string

$_localOnly

$_localOnly : boolean

Is the named range local? (i.e. can only be used on $this->_worksheet)

Type

boolean

Methods

__construct()

__construct(string  $pName = null, \PHPExcel_Worksheet  $pWorksheet, string  $pRange = 'A1', boolean  $pLocalOnly = false, \PHPExcel_Worksheet|null  $pScope = null) 

Create a new NamedRange

Parameters

string $pName
\PHPExcel_Worksheet $pWorksheet
string $pRange
boolean $pLocalOnly
\PHPExcel_Worksheet|null $pScope

Scope. Only applies when $pLocalOnly = true. Null for global scope.

Throws

\PHPExcel_Exception

getName()

getName() : string

Get name

Returns

string

setName()

setName(string  $value = null) : \PHPExcel_NamedRange

Set name

Parameters

string $value

Returns

\PHPExcel_NamedRange

getWorksheet()

getWorksheet() : \PHPExcel_Worksheet

Get worksheet

Returns

\PHPExcel_Worksheet

getRange()

getRange() : string

Get range

Returns

string

setRange()

setRange(string  $value = null) : \PHPExcel_NamedRange

Set range

Parameters

string $value

Returns

\PHPExcel_NamedRange

getLocalOnly()

getLocalOnly() : boolean

Get localOnly

Returns

boolean

setLocalOnly()

setLocalOnly(boolean  $value = false) : \PHPExcel_NamedRange

Set localOnly

Parameters

boolean $value

Returns

\PHPExcel_NamedRange

resolveRange()

resolveRange(string  $pNamedRange = '', \PHPExcel_Worksheet|null  $pSheet) : \PHPExcel_NamedRange

Resolve a named range to a regular cell range

Parameters

string $pNamedRange

Named range

\PHPExcel_Worksheet|null $pSheet

Scope. Use null for global scope

Returns

\PHPExcel_NamedRange

__clone()

__clone() 

Implement PHP __clone to create a deep clone, not just a shallow copy.