Gitee
\
admin
login
classes
systemlog
classes
Composer
Autoload
core
dzz
Guzzle
Tests
Service
Description
GuzzleHttp
Command
Exception
Guzzle
Handler
QuerySerializer
RequestLocation
ResponseLocation
Cookie
Exception
Handler
Promise
Psr7
Tests
Command
Guzzle
Asset
Exception
Handler
QuerySerializer
RequestLocation
ResponseLocation
misc
classes
Psr
Http
Message
Qcloud
Cos
Exception
Request
Tests
user
classes
login
classes
profile
classes
register
classes
sso
classes

\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 : bool

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

Type

bool —

Methods

__construct()

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

Create a new NamedRange

Parameters

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

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

Throws

\PHPExcel_Exception

Returns

mixed —

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 —

setWorksheet()

setWorksheet(\PHPExcel_Worksheet  $value = null) : \PHPExcel_NamedRange

Set worksheet

Parameters

\PHPExcel_Worksheet $value

Returns

\PHPExcel_NamedRange —

getRange()

getRange() : string

Get range

Returns

string —

setRange()

setRange(string  $value = null) : \PHPExcel_NamedRange

Set range

Parameters

string $value

Returns

\PHPExcel_NamedRange —

getLocalOnly()

getLocalOnly() : bool

Get localOnly

Returns

bool —

setLocalOnly()

setLocalOnly(bool  $value = false) : \PHPExcel_NamedRange

Set localOnly

Parameters

bool $value

Returns

\PHPExcel_NamedRange —

getScope()

getScope() : \PHPExcel_Worksheet|null

Get scope

Returns

\PHPExcel_Worksheet|null —

setScope()

setScope(\PHPExcel_Worksheet|null  $value = null) : \PHPExcel_NamedRange

Set scope

Parameters

\PHPExcel_Worksheet|null $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() : mixed

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

Returns

mixed —