Serialized.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/HashTable.php';

require_once PHPEXCEL_ROOT . 'PHPExcel/IComparable.php';

require_once PHPEXCEL_ROOT . 'PHPExcel/Worksheet.php';

require_once PHPEXCEL_ROOT . 'PHPExcel/Cell.php';

require_once PHPEXCEL_ROOT . 'PHPExcel/Writer/IWriter.php';


class PHPExcel_Writer_Serialized implements PHPExcel_Writer_IWriter
{
        private $_spreadSheet;

    public function __construct(PHPExcel $pPHPExcel = null)
    {
        // Assign PHPExcel
                $this->setPHPExcel($pPHPExcel);
    }

        public function save($pFilename = null)
        {
                if (!is_null($this->_spreadSheet)) {
                        // Garbage collect
                        $this->_spreadSheet->garbageCollect();

                        // Garbage collect...
                        foreach ($this->_spreadSheet->getAllSheets() as $sheet) {
                        $sheet->garbageCollect();
                        }

                        // Create new ZIP file and open it for writing
                        $objZip = new ZipArchive();

                        // Try opening the ZIP file
                        if ($objZip->open($pFilename, ZIPARCHIVE::OVERWRITE) !== true) {
                                if ($objZip->open($pFilename, ZIPARCHIVE::CREATE) !== true) {
                                        throw new Exception("Could not open " . $pFilename . " for writing.");
                                }
                        }

                        // Add media
                        $sheetCount = $this->_spreadSheet->getSheetCount();
                        for ($i = 0; $i < $sheetCount; ++$i) {
                                for ($j = 0; $j < $this->_spreadSheet->getSheet($i)->getDrawingCollection()->count(); ++$j) {
                                        if ($this->_spreadSheet->getSheet($i)->getDrawingCollection()->offsetGet($j) instanceof PHPExcel_Worksheet_BaseDrawing) {
                                                $imgTemp = $this->_spreadSheet->getSheet($i)->getDrawingCollection()->offsetGet($j);
                                                $objZip->addFromString('media/' . $imgTemp->getFilename(), file_get_contents($imgTemp->getPath()));
                                        }
                                }
                        }

                        // Add phpexcel.xml to the document, which represents a PHP serialized PHPExcel object
                        $objZip->addFromString('phpexcel.xml', $this->_writeSerialized($this->_spreadSheet, $pFilename));

                        // Close file
                        if ($objZip->close() === false) {
                                throw new Exception("Could not close zip file $pFilename.");
                        }
                } else {
                        throw new Exception("PHPExcel object unassigned.");
                }
        }

        public function getPHPExcel() {
                if (!is_null($this->_spreadSheet)) {
                        return $this->_spreadSheet;
                } else {
                        throw new Exception("No PHPExcel assigned.");
                }
        }

        public function setPHPExcel(PHPExcel $pPHPExcel = null) {
                $this->_spreadSheet = $pPHPExcel;
                return $this;
        }

        private function _writeSerialized(PHPExcel $pPHPExcel = null, $pFilename = '')
        {
                // Clone $pPHPExcel
                $pPHPExcel = clone $pPHPExcel;

                // Update media links
                $sheetCount = $pPHPExcel->getSheetCount();
                for ($i = 0; $i < $sheetCount; ++$i) {
                        for ($j = 0; $j < $pPHPExcel->getSheet($i)->getDrawingCollection()->count(); ++$j) {
                                if ($pPHPExcel->getSheet($i)->getDrawingCollection()->offsetGet($j) instanceof PHPExcel_Worksheet_BaseDrawing) {
                                        $imgTemp =& $pPHPExcel->getSheet($i)->getDrawingCollection()->offsetGet($j);
                                        $imgTemp->setPath('zip://' . $pFilename . '#media/' . $imgTemp->getFilename(), false);
                                }
                        }
                }

                // Create XML writer
                $objWriter = new xmlWriter();
                $objWriter->openMemory();
                $objWriter->setIndent(true);

                // XML header
                $objWriter->startDocument('1.0','UTF-8','yes');

                // PHPExcel
                $objWriter->startElement('PHPExcel');
                $objWriter->writeAttribute('version', '1.7.0');

                        // Comment
                        $objWriter->writeComment('This file has been generated using PHPExcel v1.7.0 (http://www.codeplex.com/PHPExcel). It contains a base64 encoded serialized version of the PHPExcel internal object.');

                        // Data
                        $objWriter->startElement('data');
                                $objWriter->writeCData( base64_encode(serialize($pPHPExcel)) );
                        $objWriter->endElement();

                $objWriter->endElement();

                // Return
                return $objWriter->outputMemory(true);
        }
}