Subversion Repositories eFlore/Applications.cel

<?php

/**

 * PHPExcel

 *

 * Copyright (c) 2006 - 2013 PHPExcel

 *

 * This library is free software; you can redistribute it and/or

 * modify it under the terms of the GNU Lesser General Public

 * License as published by the Free Software Foundation; either

 * version 2.1 of the License, or (at your option) any later version.

 *

 * This library is distributed in the hope that it will be useful,

 * but WITHOUT ANY WARRANTY; without even the implied warranty of

 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the GNU

 * Lesser General Public License for more details.

 *

 * You should have received a copy of the GNU Lesser General Public

 * License along with this library; if not, write to the Free Software

 * Foundation, Inc., 51 Franklin Street, Fifth Floor, Boston, MA  02110-1301  USA

 *

 * @category   PHPExcel

 * @package    PHPExcel_Writer_Excel5

 * @copyright  Copyright (c) 2006 - 2013 PHPExcel (http://www.codeplex.com/PHPExcel)

 * @license	http://www.gnu.org/licenses/old-licenses/lgpl-2.1.txt	LGPL

 * @version	##VERSION##, ##DATE##

 */

/**

 * PHPExcel_Writer_Excel5

 *

 * @category   PHPExcel

 * @package    PHPExcel_Writer_Excel5

 * @copyright  Copyright (c) 2006 - 2013 PHPExcel (http://www.codeplex.com/PHPExcel)

 */

class PHPExcel_Writer_Excel5 extends PHPExcel_Writer_Abstract implements PHPExcel_Writer_IWriter

{

	/**

	 * PHPExcel object

	 *

	 * @var PHPExcel

	 */

	private $_phpExcel;

	/**

	 * Total number of shared strings in workbook

	 *

	 * @var int

	 */

	private $_str_total		= 0;

	/**

	 * Number of unique shared strings in workbook

	 *

	 * @var int

	 */

	private $_str_unique	= 0;

	/**

	 * Array of unique shared strings in workbook

	 *

	 * @var array

	 */

	private $_str_table		= array();

	/**

	 * Color cache. Mapping between RGB value and color index.

	 *

	 * @var array

	 */

	private $_colors;

	/**

	 * Formula parser

	 *

	 * @var PHPExcel_Writer_Excel5_Parser

	 */

	private $_parser;

	/**

	 * Identifier clusters for drawings. Used in MSODRAWINGGROUP record.

	 *

	 * @var array

	 */

	private $_IDCLs;

	/**

	 * Basic OLE object summary information

	 *

	 * @var array

	 */

	private $_summaryInformation;

	/**

	 * Extended OLE object document summary information

	 *

	 * @var array

	 */

	private $_documentSummaryInformation;

	/**

	 * Create a new PHPExcel_Writer_Excel5

	 *

	 * @param	PHPExcel	$phpExcel	PHPExcel object

	 */

	public function __construct(PHPExcel $phpExcel) {

		$this->_phpExcel	= $phpExcel;

		$this->_parser		= new PHPExcel_Writer_Excel5_Parser();

	}

	/**

	 * Save PHPExcel to file

	 *

	 * @param	string		$pFilename

	 * @throws	PHPExcel_Writer_Exception

	 */

	public function save($pFilename = null) {

		// garbage collect

		$this->_phpExcel->garbageCollect();

		$saveDebugLog = PHPExcel_Calculation::getInstance($this->_phpExcel)->getDebugLog()->getWriteDebugLog();

		PHPExcel_Calculation::getInstance($this->_phpExcel)->getDebugLog()->setWriteDebugLog(FALSE);

		$saveDateReturnType = PHPExcel_Calculation_Functions::getReturnDateType();

		PHPExcel_Calculation_Functions::setReturnDateType(PHPExcel_Calculation_Functions::RETURNDATE_EXCEL);

		// initialize colors array

		$this->_colors          = array();

		// Initialise workbook writer

		$this->_writerWorkbook = new PHPExcel_Writer_Excel5_Workbook($this->_phpExcel,

																	 $this->_str_total, $this->_str_unique, $this->_str_table,

																	 $this->_colors, $this->_parser);

		// Initialise worksheet writers

		$countSheets = $this->_phpExcel->getSheetCount();

		for ($i = 0; $i < $countSheets; ++$i) {

			$this->_writerWorksheets[$i] = new PHPExcel_Writer_Excel5_Worksheet($this->_str_total, $this->_str_unique,

																			   $this->_str_table, $this->_colors,

																			   $this->_parser,

																			   $this->_preCalculateFormulas,

																			   $this->_phpExcel->getSheet($i));

		}

		// build Escher objects. Escher objects for workbooks needs to be build before Escher object for workbook.

		$this->_buildWorksheetEschers();

		$this->_buildWorkbookEscher();

		// add 15 identical cell style Xfs

		// for now, we use the first cellXf instead of cellStyleXf

		$cellXfCollection = $this->_phpExcel->getCellXfCollection();

		for ($i = 0; $i < 15; ++$i) {

			$this->_writerWorkbook->addXfWriter($cellXfCollection[0], true);

		}

		// add all the cell Xfs

		foreach ($this->_phpExcel->getCellXfCollection() as $style) {

			$this->_writerWorkbook->addXfWriter($style, false);

		}

		// add fonts from rich text eleemnts

		for ($i = 0; $i < $countSheets; ++$i) {

			foreach ($this->_writerWorksheets[$i]->_phpSheet->getCellCollection() as $cellID) {

				$cell = $this->_writerWorksheets[$i]->_phpSheet->getCell($cellID);

				$cVal = $cell->getValue();

				if ($cVal instanceof PHPExcel_RichText) {

					$elements = $cVal->getRichTextElements();

					foreach ($elements as $element) {

						if ($element instanceof PHPExcel_RichText_Run) {

							$font = $element->getFont();

							$this->_writerWorksheets[$i]->_fntHashIndex[$font->getHashCode()] = $this->_writerWorkbook->_addFont($font);

						}

					}

				}

			}

		}

		// initialize OLE file

		$workbookStreamName = 'Workbook';

		$OLE = new PHPExcel_Shared_OLE_PPS_File(PHPExcel_Shared_OLE::Asc2Ucs($workbookStreamName));

		// Write the worksheet streams before the global workbook stream,

		// because the byte sizes of these are needed in the global workbook stream

		$worksheetSizes = array();

		for ($i = 0; $i < $countSheets; ++$i) {

			$this->_writerWorksheets[$i]->close();

			$worksheetSizes[] = $this->_writerWorksheets[$i]->_datasize;

		}

		// add binary data for global workbook stream

		$OLE->append($this->_writerWorkbook->writeWorkbook($worksheetSizes));

		// add binary data for sheet streams

		for ($i = 0; $i < $countSheets; ++$i) {

			$OLE->append($this->_writerWorksheets[$i]->getData());

		}

		$this->_documentSummaryInformation = $this->_writeDocumentSummaryInformation();

		// initialize OLE Document Summary Information

		if(isset($this->_documentSummaryInformation) && !empty($this->_documentSummaryInformation)){

			$OLE_DocumentSummaryInformation = new PHPExcel_Shared_OLE_PPS_File(PHPExcel_Shared_OLE::Asc2Ucs(chr(5) . 'DocumentSummaryInformation'));

			$OLE_DocumentSummaryInformation->append($this->_documentSummaryInformation);

		}

		$this->_summaryInformation = $this->_writeSummaryInformation();

		// initialize OLE Summary Information

		if(isset($this->_summaryInformation) && !empty($this->_summaryInformation)){

		  $OLE_SummaryInformation = new PHPExcel_Shared_OLE_PPS_File(PHPExcel_Shared_OLE::Asc2Ucs(chr(5) . 'SummaryInformation'));

		  $OLE_SummaryInformation->append($this->_summaryInformation);

		}

		// define OLE Parts

		$arrRootData = array($OLE);

		// initialize OLE Properties file

		if(isset($OLE_SummaryInformation)){

			$arrRootData[] = $OLE_SummaryInformation;

		}

		// initialize OLE Extended Properties file

		if(isset($OLE_DocumentSummaryInformation)){

			$arrRootData[] = $OLE_DocumentSummaryInformation;

		}

		$root = new PHPExcel_Shared_OLE_PPS_Root(time(), time(), $arrRootData);

		// save the OLE file

		$res = $root->save($pFilename);

		PHPExcel_Calculation_Functions::setReturnDateType($saveDateReturnType);

		PHPExcel_Calculation::getInstance($this->_phpExcel)->getDebugLog()->setWriteDebugLog($saveDebugLog);

	}

	/**

	 * Set temporary storage directory

	 *

	 * @deprecated

	 * @param	string	$pValue		Temporary storage directory

	 * @throws	PHPExcel_Writer_Exception	when directory does not exist

	 * @return PHPExcel_Writer_Excel5

	 */

	public function setTempDir($pValue = '') {

		return $this;

	}

	/**

	 * Build the Worksheet Escher objects

	 *

	 */

	private function _buildWorksheetEschers()

	{

		// 1-based index to BstoreContainer

		$blipIndex = 0;

		$lastReducedSpId = 0;

		$lastSpId = 0;

		foreach ($this->_phpExcel->getAllsheets() as $sheet) {

			// sheet index

			$sheetIndex = $sheet->getParent()->getIndex($sheet);

			$escher = null;

			// check if there are any shapes for this sheet

			$filterRange = $sheet->getAutoFilter()->getRange();

			if (count($sheet->getDrawingCollection()) == 0 && empty($filterRange)) {

				continue;

			}

			// create intermediate Escher object

			$escher = new PHPExcel_Shared_Escher();

			// dgContainer

			$dgContainer = new PHPExcel_Shared_Escher_DgContainer();

			// set the drawing index (we use sheet index + 1)

			$dgId = $sheet->getParent()->getIndex($sheet) + 1;

			$dgContainer->setDgId($dgId);

			$escher->setDgContainer($dgContainer);

			// spgrContainer

			$spgrContainer = new PHPExcel_Shared_Escher_DgContainer_SpgrContainer();

			$dgContainer->setSpgrContainer($spgrContainer);

			// add one shape which is the group shape

			$spContainer = new PHPExcel_Shared_Escher_DgContainer_SpgrContainer_SpContainer();

			$spContainer->setSpgr(true);

			$spContainer->setSpType(0);

			$spContainer->setSpId(($sheet->getParent()->getIndex($sheet) + 1) << 10);

			$spgrContainer->addChild($spContainer);

			// add the shapes

			$countShapes[$sheetIndex] = 0; // count number of shapes (minus group shape), in sheet

			foreach ($sheet->getDrawingCollection() as $drawing) {

				++$blipIndex;

				++$countShapes[$sheetIndex];

				// add the shape

				$spContainer = new PHPExcel_Shared_Escher_DgContainer_SpgrContainer_SpContainer();

				// set the shape type

				$spContainer->setSpType(0x004B);

				// set the shape flag

				$spContainer->setSpFlag(0x02);

				// set the shape index (we combine 1-based sheet index and $countShapes to create unique shape index)

				$reducedSpId = $countShapes[$sheetIndex];

				$spId = $reducedSpId

					| ($sheet->getParent()->getIndex($sheet) + 1) << 10;

				$spContainer->setSpId($spId);

				// keep track of last reducedSpId

				$lastReducedSpId = $reducedSpId;

				// keep track of last spId

				$lastSpId = $spId;

				// set the BLIP index

				$spContainer->setOPT(0x4104, $blipIndex);

				// set coordinates and offsets, client anchor

				$coordinates = $drawing->getCoordinates();

				$offsetX = $drawing->getOffsetX();

				$offsetY = $drawing->getOffsetY();

				$width = $drawing->getWidth();

				$height = $drawing->getHeight();

				$twoAnchor = PHPExcel_Shared_Excel5::oneAnchor2twoAnchor($sheet, $coordinates, $offsetX, $offsetY, $width, $height);

				$spContainer->setStartCoordinates($twoAnchor['startCoordinates']);

				$spContainer->setStartOffsetX($twoAnchor['startOffsetX']);

				$spContainer->setStartOffsetY($twoAnchor['startOffsetY']);

				$spContainer->setEndCoordinates($twoAnchor['endCoordinates']);

				$spContainer->setEndOffsetX($twoAnchor['endOffsetX']);

				$spContainer->setEndOffsetY($twoAnchor['endOffsetY']);

				$spgrContainer->addChild($spContainer);

			}

			// AutoFilters

			if(!empty($filterRange)){

				$rangeBounds = PHPExcel_Cell::rangeBoundaries($filterRange);

				$iNumColStart = $rangeBounds[0][0];

				$iNumColEnd = $rangeBounds[1][0];

				$iInc = $iNumColStart;

				while($iInc <= $iNumColEnd){

					++$countShapes[$sheetIndex];

					// create an Drawing Object for the dropdown

					$oDrawing  = new PHPExcel_Worksheet_BaseDrawing();

					// get the coordinates of drawing

					$cDrawing   = PHPExcel_Cell::stringFromColumnIndex($iInc - 1) . $rangeBounds[0][1];

					$oDrawing->setCoordinates($cDrawing);

					$oDrawing->setWorksheet($sheet);

					// add the shape

					$spContainer = new PHPExcel_Shared_Escher_DgContainer_SpgrContainer_SpContainer();

					// set the shape type

					$spContainer->setSpType(0x00C9);

					// set the shape flag

					$spContainer->setSpFlag(0x01);

					// set the shape index (we combine 1-based sheet index and $countShapes to create unique shape index)

					$reducedSpId = $countShapes[$sheetIndex];

					$spId = $reducedSpId

						| ($sheet->getParent()->getIndex($sheet) + 1) << 10;

					$spContainer->setSpId($spId);

					// keep track of last reducedSpId

					$lastReducedSpId = $reducedSpId;

					// keep track of last spId

					$lastSpId = $spId;

					$spContainer->setOPT(0x007F, 0x01040104); // Protection -> fLockAgainstGrouping

					$spContainer->setOPT(0x00BF, 0x00080008); // Text -> fFitTextToShape

					$spContainer->setOPT(0x01BF, 0x00010000); // Fill Style -> fNoFillHitTest

					$spContainer->setOPT(0x01FF, 0x00080000); // Line Style -> fNoLineDrawDash

					$spContainer->setOPT(0x03BF, 0x000A0000); // Group Shape -> fPrint

					// set coordinates and offsets, client anchor

					$endCoordinates = PHPExcel_Cell::stringFromColumnIndex(PHPExcel_Cell::stringFromColumnIndex($iInc - 1));

					$endCoordinates .= $rangeBounds[0][1] + 1;

					$spContainer->setStartCoordinates($cDrawing);

					$spContainer->setStartOffsetX(0);

					$spContainer->setStartOffsetY(0);

					$spContainer->setEndCoordinates($endCoordinates);

					$spContainer->setEndOffsetX(0);

					$spContainer->setEndOffsetY(0);

					$spgrContainer->addChild($spContainer);

					$iInc++;

				}

			}

			// identifier clusters, used for workbook Escher object

			$this->_IDCLs[$dgId] = $lastReducedSpId;

			// set last shape index

			$dgContainer->setLastSpId($lastSpId);

			// set the Escher object

			$this->_writerWorksheets[$sheetIndex]->setEscher($escher);

		}

	}

	/**

	 * Build the Escher object corresponding to the MSODRAWINGGROUP record

	 */

	private function _buildWorkbookEscher()

	{

		$escher = null;

		// any drawings in this workbook?

		$found = false;

		foreach ($this->_phpExcel->getAllSheets() as $sheet) {

			if (count($sheet->getDrawingCollection()) > 0) {

				$found = true;

				break;

			}

		}

		// nothing to do if there are no drawings

		if (!$found) {

			return;

		}

		// if we reach here, then there are drawings in the workbook

		$escher = new PHPExcel_Shared_Escher();

		// dggContainer

		$dggContainer = new PHPExcel_Shared_Escher_DggContainer();

		$escher->setDggContainer($dggContainer);

		// set IDCLs (identifier clusters)

		$dggContainer->setIDCLs($this->_IDCLs);

		// this loop is for determining maximum shape identifier of all drawing

		$spIdMax = 0;

		$totalCountShapes = 0;

		$countDrawings = 0;

		foreach ($this->_phpExcel->getAllsheets() as $sheet) {

			$sheetCountShapes = 0; // count number of shapes (minus group shape), in sheet

			if (count($sheet->getDrawingCollection()) > 0) {

				++$countDrawings;

				foreach ($sheet->getDrawingCollection() as $drawing) {

					++$sheetCountShapes;

					++$totalCountShapes;

					$spId = $sheetCountShapes

						| ($this->_phpExcel->getIndex($sheet) + 1) << 10;

					$spIdMax = max($spId, $spIdMax);

				}

			}

		}

		$dggContainer->setSpIdMax($spIdMax + 1);

		$dggContainer->setCDgSaved($countDrawings);

		$dggContainer->setCSpSaved($totalCountShapes + $countDrawings); // total number of shapes incl. one group shapes per drawing

		// bstoreContainer

		$bstoreContainer = new PHPExcel_Shared_Escher_DggContainer_BstoreContainer();

		$dggContainer->setBstoreContainer($bstoreContainer);

		// the BSE's (all the images)

		foreach ($this->_phpExcel->getAllsheets() as $sheet) {

			foreach ($sheet->getDrawingCollection() as $drawing) {

				if ($drawing instanceof PHPExcel_Worksheet_Drawing) {

					$filename = $drawing->getPath();

					list($imagesx, $imagesy, $imageFormat) = getimagesize($filename);

					switch ($imageFormat) {

					case 1: // GIF, not supported by BIFF8, we convert to PNG

						$blipType = PHPExcel_Shared_Escher_DggContainer_BstoreContainer_BSE::BLIPTYPE_PNG;

						ob_start();

						imagepng(imagecreatefromgif($filename));

						$blipData = ob_get_contents();

						ob_end_clean();

						break;

					case 2: // JPEG

						$blipType = PHPExcel_Shared_Escher_DggContainer_BstoreContainer_BSE::BLIPTYPE_JPEG;

						$blipData = file_get_contents($filename);

						break;

					case 3: // PNG

						$blipType = PHPExcel_Shared_Escher_DggContainer_BstoreContainer_BSE::BLIPTYPE_PNG;

						$blipData = file_get_contents($filename);

						break;

					case 6: // Windows DIB (BMP), we convert to PNG

						$blipType = PHPExcel_Shared_Escher_DggContainer_BstoreContainer_BSE::BLIPTYPE_PNG;

						ob_start();

						imagepng(PHPExcel_Shared_Drawing::imagecreatefrombmp($filename));

						$blipData = ob_get_contents();

						ob_end_clean();

						break;

					default: continue 2;

					}

					$blip = new PHPExcel_Shared_Escher_DggContainer_BstoreContainer_BSE_Blip();

					$blip->setData($blipData);

					$BSE = new PHPExcel_Shared_Escher_DggContainer_BstoreContainer_BSE();

					$BSE->setBlipType($blipType);

					$BSE->setBlip($blip);

					$bstoreContainer->addBSE($BSE);

				} else if ($drawing instanceof PHPExcel_Worksheet_MemoryDrawing) {

					switch ($drawing->getRenderingFunction()) {

					case PHPExcel_Worksheet_MemoryDrawing::RENDERING_JPEG:

						$blipType = PHPExcel_Shared_Escher_DggContainer_BstoreContainer_BSE::BLIPTYPE_JPEG;

						$renderingFunction = 'imagejpeg';

						break;

					case PHPExcel_Worksheet_MemoryDrawing::RENDERING_GIF:

					case PHPExcel_Worksheet_MemoryDrawing::RENDERING_PNG:

					case PHPExcel_Worksheet_MemoryDrawing::RENDERING_DEFAULT:

						$blipType = PHPExcel_Shared_Escher_DggContainer_BstoreContainer_BSE::BLIPTYPE_PNG;

						$renderingFunction = 'imagepng';

						break;

					}

					ob_start();

					call_user_func($renderingFunction, $drawing->getImageResource());

					$blipData = ob_get_contents();

					ob_end_clean();

					$blip = new PHPExcel_Shared_Escher_DggContainer_BstoreContainer_BSE_Blip();

					$blip->setData($blipData);

					$BSE = new PHPExcel_Shared_Escher_DggContainer_BstoreContainer_BSE();

					$BSE->setBlipType($blipType);

					$BSE->setBlip($blip);

					$bstoreContainer->addBSE($BSE);

				}

			}

		}

		// Set the Escher object

		$this->_writerWorkbook->setEscher($escher);

	}

	/**

	 * Build the OLE Part for DocumentSummary Information

	 * @return string

	 */

	private function _writeDocumentSummaryInformation(){

		// offset: 0; size: 2; must be 0xFE 0xFF (UTF-16 LE byte order mark)

		$data = pack('v', 0xFFFE);

		// offset: 2; size: 2;

		$data .= pack('v', 0x0000);

		// offset: 4; size: 2; OS version

		$data .= pack('v', 0x0106);

		// offset: 6; size: 2; OS indicator

		$data .= pack('v', 0x0002);

		// offset: 8; size: 16

		$data .= pack('VVVV', 0x00, 0x00, 0x00, 0x00);

		// offset: 24; size: 4; section count

		$data .= pack('V', 0x0001);

		// offset: 28; size: 16; first section's class id: 02 d5 cd d5 9c 2e 1b 10 93 97 08 00 2b 2c f9 ae

		$data .= pack('vvvvvvvv', 0xD502, 0xD5CD, 0x2E9C, 0x101B, 0x9793, 0x0008, 0x2C2B, 0xAEF9);

		// offset: 44; size: 4; offset of the start

		$data .= pack('V', 0x30);

		// SECTION

		$dataSection = array();

		$dataSection_NumProps = 0;

		$dataSection_Summary = '';

		$dataSection_Content = '';

		// GKPIDDSI_CODEPAGE: CodePage

		$dataSection[] = array('summary'=> array('pack' => 'V', 'data' => 0x01),

							   'offset' => array('pack' => 'V'),

							   'type' 	=> array('pack' => 'V', 'data' => 0x02), // 2 byte signed integer

							   'data'	=> array('data' => 1252));

		$dataSection_NumProps++;

		// GKPIDDSI_CATEGORY : Category

		if($this->_phpExcel->getProperties()->getCategory()){

			$dataProp = $this->_phpExcel->getProperties()->getCategory();

			$dataSection[] = array('summary'=> array('pack' => 'V', 'data' => 0x02),

								   'offset' => array('pack' => 'V'),

								   'type' 	=> array('pack' => 'V', 'data' => 0x1E),

								   'data'	=> array('data' => $dataProp, 'length' => strlen($dataProp)));

			$dataSection_NumProps++;

		}

		// GKPIDDSI_VERSION :Version of the application that wrote the property storage

		$dataSection[] = array('summary'=> array('pack' => 'V', 'data' => 0x17),

							   'offset' => array('pack' => 'V'),

							   'type' 	=> array('pack' => 'V', 'data' => 0x03),

							   'data'	=> array('pack' => 'V', 'data' => 0x000C0000));

		$dataSection_NumProps++;

		// GKPIDDSI_SCALE : FALSE

		$dataSection[] = array('summary'=> array('pack' => 'V', 'data' => 0x0B),

							   'offset' => array('pack' => 'V'),

							   'type' 	=> array('pack' => 'V', 'data' => 0x0B),

							   'data'	=> array('data' => false));

		$dataSection_NumProps++;

		// GKPIDDSI_LINKSDIRTY : True if any of the values for the linked properties have changed outside of the application

		$dataSection[] = array('summary'=> array('pack' => 'V', 'data' => 0x10),

							   'offset' => array('pack' => 'V'),

							   'type' 	=> array('pack' => 'V', 'data' => 0x0B),

							   'data'	=> array('data' => false));

		$dataSection_NumProps++;

		// GKPIDDSI_SHAREDOC : FALSE

		$dataSection[] = array('summary'=> array('pack' => 'V', 'data' => 0x13),

							   'offset' => array('pack' => 'V'),

							   'type' 	=> array('pack' => 'V', 'data' => 0x0B),

							   'data'	=> array('data' => false));

		$dataSection_NumProps++;

		// GKPIDDSI_HYPERLINKSCHANGED : True if any of the values for the _PID_LINKS (hyperlink text) have changed outside of the application

		$dataSection[] = array('summary'=> array('pack' => 'V', 'data' => 0x16),

							   'offset' => array('pack' => 'V'),

							   'type' 	=> array('pack' => 'V', 'data' => 0x0B),

							   'data'	=> array('data' => false));

		$dataSection_NumProps++;

		// GKPIDDSI_DOCSPARTS

		// MS-OSHARED p75 (2.3.3.2.2.1)

		// Structure is VtVecUnalignedLpstrValue (2.3.3.1.9)

		// cElements

		$dataProp = pack('v', 0x0001);

		$dataProp .= pack('v', 0x0000);

		// array of UnalignedLpstr

		  // cch

		  $dataProp .= pack('v', 0x000A);

		  $dataProp .= pack('v', 0x0000);

		  // value

		  $dataProp .= 'Worksheet'.chr(0);

		$dataSection[] = array('summary'=> array('pack' => 'V', 'data' => 0x0D),

							   'offset' => array('pack' => 'V'),

							   'type' 	=> array('pack' => 'V', 'data' => 0x101E),

							   'data'	=> array('data' => $dataProp, 'length' => strlen($dataProp)));

		$dataSection_NumProps++;

		// GKPIDDSI_HEADINGPAIR

		// VtVecHeadingPairValue

		  // cElements

		  $dataProp = pack('v', 0x0002);

		  $dataProp .= pack('v', 0x0000);

		  // Array of vtHeadingPair

		    // vtUnalignedString - headingString

		      // stringType

		      $dataProp .= pack('v', 0x001E);

		      // padding

		      $dataProp .= pack('v', 0x0000);

		      // UnalignedLpstr

		        // cch

		        $dataProp .= pack('v', 0x0013);

		        $dataProp .= pack('v', 0x0000);

		        // value

		        $dataProp .= 'Feuilles de calcul';

		    // vtUnalignedString - headingParts

		      // wType : 0x0003 = 32 bit signed integer

		      $dataProp .= pack('v', 0x0300);

		      // padding

		      $dataProp .= pack('v', 0x0000);

		      // value

		      $dataProp .= pack('v', 0x0100);

		      $dataProp .= pack('v', 0x0000);

			  $dataProp .= pack('v', 0x0000);

		      $dataProp .= pack('v', 0x0000);

        $dataSection[] = array('summary'=> array('pack' => 'V', 'data' => 0x0C),

        					   'offset' => array('pack' => 'V'),

        					   'type' 	=> array('pack' => 'V', 'data' => 0x100C),

        					   'data'	=> array('data' => $dataProp, 'length' => strlen($dataProp)));

        $dataSection_NumProps++;

		// 		4 	Section Length

		//		4 	Property count

		//		8 * $dataSection_NumProps (8 =  ID (4) + OffSet(4))

		$dataSection_Content_Offset = 8 + $dataSection_NumProps * 8;

		foreach ($dataSection as $dataProp){

			// Summary

			$dataSection_Summary .= pack($dataProp['summary']['pack'], $dataProp['summary']['data']);

			// Offset

			$dataSection_Summary .= pack($dataProp['offset']['pack'], $dataSection_Content_Offset);

			// DataType

			$dataSection_Content .= pack($dataProp['type']['pack'], $dataProp['type']['data']);

			// Data

			if($dataProp['type']['data'] == 0x02){ // 2 byte signed integer

				$dataSection_Content .= pack('V', $dataProp['data']['data']);

				$dataSection_Content_Offset += 4 + 4;

			}

			elseif($dataProp['type']['data'] == 0x03){ // 4 byte signed integer

				$dataSection_Content .= pack('V', $dataProp['data']['data']);

				$dataSection_Content_Offset += 4 + 4;

			}

			elseif($dataProp['type']['data'] == 0x0B){ // Boolean

				if($dataProp['data']['data'] == false){

					$dataSection_Content .= pack('V', 0x0000);

				} else {

					$dataSection_Content .= pack('V', 0x0001);

				}

				$dataSection_Content_Offset += 4 + 4;

			}

			elseif($dataProp['type']['data'] == 0x1E){ // null-terminated string prepended by dword string length

				// Null-terminated string

				$dataProp['data']['data'] .= chr(0);

				$dataProp['data']['length'] += 1;

				// Complete the string with null string for being a %4

				$dataProp['data']['length'] = $dataProp['data']['length'] + ((4 - $dataProp['data']['length'] % 4)==4 ? 0 : (4 - $dataProp['data']['length'] % 4));

				$dataProp['data']['data'] = str_pad($dataProp['data']['data'], $dataProp['data']['length'], chr(0), STR_PAD_RIGHT);

				$dataSection_Content .= pack('V', $dataProp['data']['length']);

				$dataSection_Content .= $dataProp['data']['data'];

				$dataSection_Content_Offset += 4 + 4 + strlen($dataProp['data']['data']);

			}

			elseif($dataProp['type']['data'] == 0x40){ // Filetime (64-bit value representing the number of 100-nanosecond intervals since January 1, 1601)

				$dataSection_Content .= $dataProp['data']['data'];

				$dataSection_Content_Offset += 4 + 8;

			}

			else {

				// Data Type Not Used at the moment

				$dataSection_Content .= $dataProp['data']['data'];

				$dataSection_Content_Offset += 4 + $dataProp['data']['length'];

			}

		}

		// Now $dataSection_Content_Offset contains the size of the content

		// section header

		// offset: $secOffset; size: 4; section length

		// 		+ x  Size of the content (summary + content)

		$data .= pack('V', $dataSection_Content_Offset);

		// offset: $secOffset+4; size: 4; property count

		$data .= pack('V', $dataSection_NumProps);

		// Section Summary

		$data .= $dataSection_Summary;

		// Section Content

		$data .= $dataSection_Content;

		return $data;

	}

	/**

	 * Build the OLE Part for Summary Information

	 * @return string

	 */

	private function _writeSummaryInformation(){

		// offset: 0; size: 2; must be 0xFE 0xFF (UTF-16 LE byte order mark)

		$data = pack('v', 0xFFFE);

		// offset: 2; size: 2;

		$data .= pack('v', 0x0000);

		// offset: 4; size: 2; OS version

		$data .= pack('v', 0x0106);

		// offset: 6; size: 2; OS indicator

		$data .= pack('v', 0x0002);

		// offset: 8; size: 16

		$data .= pack('VVVV', 0x00, 0x00, 0x00, 0x00);

		// offset: 24; size: 4; section count

		$data .= pack('V', 0x0001);

		// offset: 28; size: 16; first section's class id: e0 85 9f f2 f9 4f 68 10 ab 91 08 00 2b 27 b3 d9

		$data .= pack('vvvvvvvv', 0x85E0, 0xF29F, 0x4FF9, 0x1068, 0x91AB, 0x0008, 0x272B, 0xD9B3);

		// offset: 44; size: 4; offset of the start

		$data .= pack('V', 0x30);

		// SECTION

		$dataSection = array();

		$dataSection_NumProps = 0;

		$dataSection_Summary = '';

		$dataSection_Content = '';

		// CodePage : CP-1252

		$dataSection[] = array('summary'=> array('pack' => 'V', 'data' => 0x01),

							   'offset' => array('pack' => 'V'),

							   'type' 	=> array('pack' => 'V', 'data' => 0x02), // 2 byte signed integer

							   'data'	=> array('data' => 1252));

		$dataSection_NumProps++;

		//	Title

		if($this->_phpExcel->getProperties()->getTitle()){

			$dataProp = $this->_phpExcel->getProperties()->getTitle();

			$dataSection[] = array('summary'=> array('pack' => 'V', 'data' => 0x02),

								   'offset' => array('pack' => 'V'),

								   'type' 	=> array('pack' => 'V', 'data' => 0x1E), // null-terminated string prepended by dword string length

								   'data'	=> array('data' => $dataProp, 'length' => strlen($dataProp)));

			$dataSection_NumProps++;

		}

		//	Subject

		if($this->_phpExcel->getProperties()->getSubject()){

			$dataProp = $this->_phpExcel->getProperties()->getSubject();

			$dataSection[] = array('summary'=> array('pack' => 'V', 'data' => 0x03),

								   'offset' => array('pack' => 'V'),

								   'type' 	=> array('pack' => 'V', 'data' => 0x1E), // null-terminated string prepended by dword string length

								   'data'	=> array('data' => $dataProp, 'length' => strlen($dataProp)));

			$dataSection_NumProps++;

		}

		//	Author (Creator)

		if($this->_phpExcel->getProperties()->getCreator()){

			$dataProp = $this->_phpExcel->getProperties()->getCreator();

			$dataSection[] = array('summary'=> array('pack' => 'V', 'data' => 0x04),

								   'offset' => array('pack' => 'V'),

								   'type' 	=> array('pack' => 'V', 'data' => 0x1E), // null-terminated string prepended by dword string length

								   'data'	=> array('data' => $dataProp, 'length' => strlen($dataProp)));

			$dataSection_NumProps++;

		}

		//	Keywords

		if($this->_phpExcel->getProperties()->getKeywords()){

			$dataProp = $this->_phpExcel->getProperties()->getKeywords();

			$dataSection[] = array('summary'=> array('pack' => 'V', 'data' => 0x05),

								   'offset' => array('pack' => 'V'),

								   'type' 	=> array('pack' => 'V', 'data' => 0x1E), // null-terminated string prepended by dword string length

								   'data'	=> array('data' => $dataProp, 'length' => strlen($dataProp)));

			$dataSection_NumProps++;

		}

		//	Comments (Description)

		if($this->_phpExcel->getProperties()->getDescription()){

			$dataProp = $this->_phpExcel->getProperties()->getDescription();

			$dataSection[] = array('summary'=> array('pack' => 'V', 'data' => 0x06),

								   'offset' => array('pack' => 'V'),

								   'type' 	=> array('pack' => 'V', 'data' => 0x1E), // null-terminated string prepended by dword string length

								   'data'	=> array('data' => $dataProp, 'length' => strlen($dataProp)));

			$dataSection_NumProps++;

		}

		//	Last Saved By (LastModifiedBy)

		if($this->_phpExcel->getProperties()->getLastModifiedBy()){

			$dataProp = $this->_phpExcel->getProperties()->getLastModifiedBy();

			$dataSection[] = array('summary'=> array('pack' => 'V', 'data' => 0x08),

								   'offset' => array('pack' => 'V'),

								   'type' 	=> array('pack' => 'V', 'data' => 0x1E), // null-terminated string prepended by dword string length

								   'data'	=> array('data' => $dataProp, 'length' => strlen($dataProp)));

			$dataSection_NumProps++;

		}

		//	Created Date/Time

		if($this->_phpExcel->getProperties()->getCreated()){

			$dataProp = $this->_phpExcel->getProperties()->getCreated();

			$dataSection[] = array('summary'=> array('pack' => 'V', 'data' => 0x0C),

								   'offset' => array('pack' => 'V'),

								   'type' 	=> array('pack' => 'V', 'data' => 0x40), // Filetime (64-bit value representing the number of 100-nanosecond intervals since January 1, 1601)

								   'data'	=> array('data' => PHPExcel_Shared_OLE::LocalDate2OLE($dataProp)));

			$dataSection_NumProps++;

		}

		//	Modified Date/Time

		if($this->_phpExcel->getProperties()->getModified()){

			$dataProp = $this->_phpExcel->getProperties()->getModified();

			$dataSection[] = array('summary'=> array('pack' => 'V', 'data' => 0x0D),

								   'offset' => array('pack' => 'V'),

								   'type' 	=> array('pack' => 'V', 'data' => 0x40), // Filetime (64-bit value representing the number of 100-nanosecond intervals since January 1, 1601)

								   'data'	=> array('data' => PHPExcel_Shared_OLE::LocalDate2OLE($dataProp)));

			$dataSection_NumProps++;

		}

		//	Security

		$dataSection[] = array('summary'=> array('pack' => 'V', 'data' => 0x13),

							   'offset' => array('pack' => 'V'),

							   'type' 	=> array('pack' => 'V', 'data' => 0x03), // 4 byte signed integer

							   'data'	=> array('data' => 0x00));

		$dataSection_NumProps++;

		// 		4 	Section Length

		//		4 	Property count

		//		8 * $dataSection_NumProps (8 =  ID (4) + OffSet(4))

		$dataSection_Content_Offset = 8 + $dataSection_NumProps * 8;

		foreach ($dataSection as $dataProp){

			// Summary

			$dataSection_Summary .= pack($dataProp['summary']['pack'], $dataProp['summary']['data']);

			// Offset

			$dataSection_Summary .= pack($dataProp['offset']['pack'], $dataSection_Content_Offset);

			// DataType

			$dataSection_Content .= pack($dataProp['type']['pack'], $dataProp['type']['data']);

			// Data

			if($dataProp['type']['data'] == 0x02){ // 2 byte signed integer

				$dataSection_Content .= pack('V', $dataProp['data']['data']);

				$dataSection_Content_Offset += 4 + 4;

			}

			elseif($dataProp['type']['data'] == 0x03){ // 4 byte signed integer

				$dataSection_Content .= pack('V', $dataProp['data']['data']);

				$dataSection_Content_Offset += 4 + 4;

			}

			elseif($dataProp['type']['data'] == 0x1E){ // null-terminated string prepended by dword string length

				// Null-terminated string

				$dataProp['data']['data'] .= chr(0);

				$dataProp['data']['length'] += 1;

				// Complete the string with null string for being a %4

				$dataProp['data']['length'] = $dataProp['data']['length'] + ((4 - $dataProp['data']['length'] % 4)==4 ? 0 : (4 - $dataProp['data']['length'] % 4));

				$dataProp['data']['data'] = str_pad($dataProp['data']['data'], $dataProp['data']['length'], chr(0), STR_PAD_RIGHT);

				$dataSection_Content .= pack('V', $dataProp['data']['length']);

				$dataSection_Content .= $dataProp['data']['data'];

				$dataSection_Content_Offset += 4 + 4 + strlen($dataProp['data']['data']);

			}

			elseif($dataProp['type']['data'] == 0x40){ // Filetime (64-bit value representing the number of 100-nanosecond intervals since January 1, 1601)

				$dataSection_Content .= $dataProp['data']['data'];

				$dataSection_Content_Offset += 4 + 8;

			}

			else {

				// Data Type Not Used at the moment

			}

		}

		// Now $dataSection_Content_Offset contains the size of the content

		// section header

		// offset: $secOffset; size: 4; section length

		// 		+ x  Size of the content (summary + content)

		$data .= pack('V', $dataSection_Content_Offset);

		// offset: $secOffset+4; size: 4; property count

		$data .= pack('V', $dataSection_NumProps);

		// Section Summary

		$data .= $dataSection_Summary;

		// Section Content

		$data .= $dataSection_Content;

		return $data;

	}

}