/** * Serialize PHPExcel object to XML * * @param PHPExcel $pPHPExcel * @param string $pFilename * @return string XML Output * @throws Exception */ 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', '##VERSION##'); // Comment $objWriter->writeComment('This file has been generated using PHPExcel v##VERSION## (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); }