PHPExcel\Template

<?php
/**
 * Created by PhpStorm.
 * User: Mozart
 * Date: 28.11.2014
 * Time: 0:18
 */


class PHPExcel_Template {
    /**
     * ZipArchive object
     *
     * @var mixed
     */
    private $zipClass;
    /**
     * Temporary file name
     *
     * @var string
     */
    private $tempFileName;
    /**
     * Document XML
     *
     * @var string
     */
    private $documentXML;

    function __construct($strFilename) {

        $this->tempFileName = tempnam(sys_get_temp_dir(), '');
        if ($this->tempFileName === false) {
            throw new Exception('Could not create temporary file with unique name in the default temporary directory.');
        }
        // Copy the source File to the temp File
        if (!copy($strFilename, $this->tempFileName)) {
            throw new Exception("Could not copy the template from {$strFilename} to {$this->tempFileName}.");
        }
        $this->zipClass = new PHPExcel_Shared_ZipArchive();
        $this->zipClass->open($this->tempFileName);

        $this->documentXML = $this->zipClass->getFromName('xl/sharedStrings.xml');

    }

    public function save()
    {
        // Close zip file
        if ($this->zipClass->close() === false) {
            throw new PHPExcel_Exception('Could not close zip file.');
        }
        return $this->tempFileName;
    }

    public function saveAs($strFilename)
    {
        $this->zipClass->addFromString('xl/sharedStrings.xml', $this->documentXML);
        $tempFilename = $this->save();
        if (file_exists($strFilename)) {
            unlink($strFilename);
        }
        rename($tempFilename, $strFilename);
    }

    public function getString() {
        return $this->documentXML;
    }

    protected function getVariablesForPart($documentPartXML)
    {
        preg_match_all('/\$\{(.*?)}/i', $documentPartXML, $matches);
        return $matches[1];
    }

    public function getVariables()
    {
        $variables = $this->getVariablesForPart($this->documentXML);
        return array_unique($variables);
    }


    protected function setValueForPart($documentPartXML, $search, $replace, $limit)
    {
        $pattern = '|\$\{([^\}]+)\}|U';
        preg_match_all($pattern, $documentPartXML, $matches);
        foreach ($matches[0] as $value) {
            $valueCleaned = preg_replace('/<[^>]+>/', '', $value);
            $valueCleaned = preg_replace('/<\/[^>]+>/', '', $valueCleaned);
            $documentPartXML = str_replace($value, $valueCleaned, $documentPartXML);
        }
        if (substr($search, 0, 2) !== '${' && substr($search, -1) !== '}') {
            $search = '${' . $search . '}';
        }
        $replace = htmlspecialchars($replace);
        $regExpDelim = '/';
        $escapedSearch = preg_quote($search, $regExpDelim);
        return preg_replace("{$regExpDelim}{$escapedSearch}{$regExpDelim}u", $replace, $documentPartXML, $limit);
    }

    public function setValue($search, $replace, $limit = -1)
    {
        $this->documentXML = $this->setValueForPart($this->documentXML, $search, $replace, $limit);
    }

}