$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 |