NamedRange.php

Go to the documentation of this file.

<?php
if (!defined('PHPEXCEL_ROOT')) {
        define('PHPEXCEL_ROOT', dirname(__FILE__) . '/../');
}

require_once PHPEXCEL_ROOT . 'PHPExcel.php';

require_once PHPEXCEL_ROOT . 'PHPExcel/Worksheet.php';

require_once PHPEXCEL_ROOT . 'PHPExcel/ReferenceHelper.php';


class PHPExcel_NamedRange
{
        private $_name;

        private $_worksheet;

        private $_range;

        private $_localOnly;

    public function __construct($pName = null, PHPExcel_Worksheet $pWorksheet, $pRange = 'A1', $pLocalOnly = false)
    {
        // Validate data
        if (is_null($pName) || is_null($pWorksheet)|| is_null($pRange)) {
                throw new Exception('Parameters can not be null.');
        }

        // Set local members
        $this->_name            = $pName;
        $this->_worksheet       = $pWorksheet;
        $this->_range           = $pRange;
        $this->_localOnly       = $pLocalOnly;
    }

    public function getName() {
        return $this->_name;
    }

    public function setName($value = null) {
        if (!is_null($value)) {
                // Old title
                $oldTitle = $this->_name;

                // Re-attach
                if (!is_null($this->_worksheet)) {
                        $this->_worksheet->getParent()->removeNamedRange($this->_name,$this->_worksheet);
                }
                $this->_name = $value;

                if (!is_null($this->_worksheet)) {
                        $this->_worksheet->getParent()->addNamedRange($this);
                }

                // New title
                $newTitle = $this->_name;
                PHPExcel_ReferenceHelper::getInstance()->updateNamedFormulas($this->_worksheet->getParent(), $oldTitle, $newTitle);
        }
        return $this;
    }

    public function getWorksheet() {
        return $this->_worksheet;
    }

    public function setWorksheet(PHPExcel_Worksheet $value = null) {
        if (!is_null($value)) {
                $this->_worksheet = $value;
        }
        return $this;
    }

    public function getRange() {
        return $this->_range;
    }

    public function setRange($value = null) {
        if (!is_null($value)) {
                $this->_range = $value;
        }
        return $this;
    }

    public function getLocalOnly() {
        return $this->_localOnly;
    }

    public function setLocalOnly($value = false) {
        $this->_localOnly = $value;
        return $this;
    }

    public static function resolveRange($pNamedRange = '', PHPExcel_Worksheet $pSheet) {
                return $pSheet->getParent()->getNamedRange($pNamedRange, $pSheet);
    }

        public function __clone() {
                $vars = get_object_vars($this);
                foreach ($vars as $key => $value) {
                        if (is_object($value)) {
                                $this->$key = clone $value;
                        } else {
                                $this->$key = $value;
                        }
                }
        }
}