summaryrefslogtreecommitdiffstats
path: root/vendor/phpoffice/phpspreadsheet/src/PhpSpreadsheet/NamedRange.php
diff options
context:
space:
mode:
Diffstat (limited to '')
-rw-r--r--vendor/phpoffice/phpspreadsheet/src/PhpSpreadsheet/NamedRange.php55
1 files changed, 55 insertions, 0 deletions
diff --git a/vendor/phpoffice/phpspreadsheet/src/PhpSpreadsheet/NamedRange.php b/vendor/phpoffice/phpspreadsheet/src/PhpSpreadsheet/NamedRange.php
new file mode 100644
index 0000000..f4d0f71
--- /dev/null
+++ b/vendor/phpoffice/phpspreadsheet/src/PhpSpreadsheet/NamedRange.php
@@ -0,0 +1,55 @@
+<?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);
+ }
+}