$name
$name : string
Range name.
$worksheet : \PhpOffice\PhpSpreadsheet\Worksheet\Worksheet
Worksheet on which the named range can be resolved.
$scope : \PhpOffice\PhpSpreadsheet\Worksheet\Worksheet
Scope.
__construct(string $pName, \PhpOffice\PhpSpreadsheet\Worksheet\Worksheet $pWorksheet, string $pRange = 'A1', boolean $pLocalOnly = false, null|\PhpOffice\PhpSpreadsheet\Worksheet\Worksheet $pScope = null)
Create a new NamedRange.
string | $pName | |
\PhpOffice\PhpSpreadsheet\Worksheet\Worksheet | $pWorksheet | |
string | $pRange | |
boolean | $pLocalOnly | |
null|\PhpOffice\PhpSpreadsheet\Worksheet\Worksheet | $pScope | Scope. Only applies when $pLocalOnly = true. Null for global scope. |
setName(string $value) : \PhpOffice\PhpSpreadsheet\NamedRange
Set name.
string | $value |
getWorksheet() : \PhpOffice\PhpSpreadsheet\Worksheet\Worksheet
Get worksheet.
setWorksheet(\PhpOffice\PhpSpreadsheet\Worksheet\Worksheet $value = null) : \PhpOffice\PhpSpreadsheet\NamedRange
Set worksheet.
\PhpOffice\PhpSpreadsheet\Worksheet\Worksheet | $value |
setRange(string $value) : \PhpOffice\PhpSpreadsheet\NamedRange
Set range.
string | $value |
setLocalOnly(boolean $value) : \PhpOffice\PhpSpreadsheet\NamedRange
Set localOnly.
boolean | $value |
getScope() : null|\PhpOffice\PhpSpreadsheet\Worksheet\Worksheet
Get scope.
setScope(null|\PhpOffice\PhpSpreadsheet\Worksheet\Worksheet $value = null) : \PhpOffice\PhpSpreadsheet\NamedRange
Set scope.
null|\PhpOffice\PhpSpreadsheet\Worksheet\Worksheet | $value |
resolveRange(string $pNamedRange, null|\PhpOffice\PhpSpreadsheet\Worksheet\Worksheet $pSheet) : \PhpOffice\PhpSpreadsheet\NamedRange
Resolve a named range to a regular cell range.
string | $pNamedRange | Named range |
null|\PhpOffice\PhpSpreadsheet\Worksheet\Worksheet | $pSheet | Scope. Use null for global scope |