REGEXP_IDENTIFY_FORMULA
REGEXP_IDENTIFY_FORMULA = '[^_\\p{N}\\p{L}:, \\$\'!]'
$name : string
Name.
$worksheet : \PhpOffice\PhpSpreadsheet\Worksheet\Worksheet
Worksheet on which the defined name can be resolved.
$value : string
Value of the named object.
$localOnly : bool
Is the defined named local? (i.e. can only be used on $this->worksheet).
$scope : \PhpOffice\PhpSpreadsheet\Worksheet\Worksheet
Scope.
$isFormula : bool
Whether this is a named range or a named formula.
__construct(string $name, ?\PhpOffice\PhpSpreadsheet\Worksheet\Worksheet $worksheet = null, string $range = 'A1', bool $localOnly = false, ?\PhpOffice\PhpSpreadsheet\Worksheet\Worksheet $scope = null) : mixed
Create a new Named Range.
| string | $name | |
| ?\PhpOffice\PhpSpreadsheet\Worksheet\Worksheet | $worksheet | |
| string | $range | |
| bool | $localOnly | |
| ?\PhpOffice\PhpSpreadsheet\Worksheet\Worksheet | $scope |
createInstance(string $name, ?\PhpOffice\PhpSpreadsheet\Worksheet\Worksheet $worksheet = null, ?string $value = null, bool $localOnly = false, ?\PhpOffice\PhpSpreadsheet\Worksheet\Worksheet $scope = null) : self
Create a new defined name, either a range or a formula.
| string | $name | |
| ?\PhpOffice\PhpSpreadsheet\Worksheet\Worksheet | $worksheet | |
| ?string | $value | |
| bool | $localOnly | |
| ?\PhpOffice\PhpSpreadsheet\Worksheet\Worksheet | $scope |
<?php
namespace PhpOffice\PhpSpreadsheet;
use PhpOffice\PhpSpreadsheet\Cell\Coordinate;
use PhpOffice\PhpSpreadsheet\Worksheet\Worksheet;
class NamedRange extends DefinedName
{
/**
* Create a new Named Range.
*/
public function __construct(
string $name,
?Worksheet $worksheet = null,
string $range = 'A1',
bool $localOnly = false,
?Worksheet $scope = null
) {
if ($worksheet === null && $scope === null) {
throw new Exception('You must specify a worksheet or a scope for a Named Range');
}
parent::__construct($name, $worksheet, $range, $localOnly, $scope);
}
/**
* Get the range value.
*/
public function getRange(): string
{
return $this->value;
}
/**
* Set the range value.
*/
public function setRange(string $range): self
{
if (!empty($range)) {
$this->value = $range;
}
return $this;
}
public function getCellsInRange(): array
{
$range = $this->value;
if (substr($range, 0, 1) === '=') {
$range = substr($range, 1);
}
return Coordinate::extractAllCellReferencesInRange($range);
}
}