$name
$name : string
Range name.
$name : string
Range name.
$worksheet : \PhpOffice\PhpSpreadsheet\Worksheet\Worksheet
Worksheet on which the named range can be resolved.
$range : string
Range of the referenced cells.
$localOnly : bool
Is the named range local? (i.e. can only be used on $this->worksheet).
$scope : \PhpOffice\PhpSpreadsheet\Worksheet\Worksheet
Scope.
__construct(string $pName, \PhpOffice\PhpSpreadsheet\Worksheet\Worksheet $pWorksheet, string $pRange = 'A1', bool $pLocalOnly = false, null|\PhpOffice\PhpSpreadsheet\Worksheet\Worksheet $pScope = null) : mixed
Create a new NamedRange.
string | $pName | |
\PhpOffice\PhpSpreadsheet\Worksheet\Worksheet | $pWorksheet | |
string | $pRange | |
bool | $pLocalOnly | |
null|\PhpOffice\PhpSpreadsheet\Worksheet\Worksheet | $pScope | Scope. Only applies when $pLocalOnly = true. Null for global scope. |
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 |