DocProps.php

Go to the documentation of this file.

<?php
class PHPExcel_Writer_Excel2007_DocProps extends PHPExcel_Writer_Excel2007_WriterPart
{
        public function writeDocPropsApp(PHPExcel $pPHPExcel = null)
        {
                // Create XML writer
                $objWriter = null;
                if ($this->getParentWriter()->getUseDiskCaching()) {
                        $objWriter = new PHPExcel_Shared_XMLWriter(PHPExcel_Shared_XMLWriter::STORAGE_DISK, $this->getParentWriter()->getDiskCachingDirectory());
                } else {
                        $objWriter = new PHPExcel_Shared_XMLWriter(PHPExcel_Shared_XMLWriter::STORAGE_MEMORY);
                }

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

                // Properties
                $objWriter->startElement('Properties');
                        $objWriter->writeAttribute('xmlns', 'http://schemas.openxmlformats.org/officeDocument/2006/extended-properties');
                        $objWriter->writeAttribute('xmlns:vt', 'http://schemas.openxmlformats.org/officeDocument/2006/docPropsVTypes');

                        // Application
                        $objWriter->writeElement('Application',         'Microsoft Excel');

                        // DocSecurity
                        $objWriter->writeElement('DocSecurity',         '0');

                        // ScaleCrop
                        $objWriter->writeElement('ScaleCrop',           'false');

                        // HeadingPairs
                        $objWriter->startElement('HeadingPairs');

                                // Vector
                                $objWriter->startElement('vt:vector');
                                        $objWriter->writeAttribute('size',              '2');
                                        $objWriter->writeAttribute('baseType',  'variant');

                                        // Variant
                                        $objWriter->startElement('vt:variant');
                                                $objWriter->writeElement('vt:lpstr',    'Worksheets');
                                        $objWriter->endElement();

                                        // Variant
                                        $objWriter->startElement('vt:variant');
                                                $objWriter->writeElement('vt:i4',               $pPHPExcel->getSheetCount());
                                        $objWriter->endElement();

                                $objWriter->endElement();

                        $objWriter->endElement();

                        // TitlesOfParts
                        $objWriter->startElement('TitlesOfParts');

                                // Vector
                                $objWriter->startElement('vt:vector');
                                        $objWriter->writeAttribute('size',              $pPHPExcel->getSheetCount());
                                        $objWriter->writeAttribute('baseType',  'lpstr');

                                        $sheetCount = $pPHPExcel->getSheetCount();
                                        for ($i = 0; $i < $sheetCount; ++$i) {
                                                $objWriter->writeElement('vt:lpstr', $pPHPExcel->getSheet($i)->getTitle());
                                        }

                                $objWriter->endElement();

                        $objWriter->endElement();

                        // Company
                        $objWriter->writeElement('Company',                     $pPHPExcel->getProperties()->getCompany());

                        // Company
                        $objWriter->writeElement('Manager',                     $pPHPExcel->getProperties()->getManager());

                        // LinksUpToDate
                        $objWriter->writeElement('LinksUpToDate',               'false');

                        // SharedDoc
                        $objWriter->writeElement('SharedDoc',                   'false');

                        // HyperlinksChanged
                        $objWriter->writeElement('HyperlinksChanged',   'false');

                        // AppVersion
                        $objWriter->writeElement('AppVersion',                  '12.0000');

                $objWriter->endElement();

                // Return
                return $objWriter->getData();
        }

        public function writeDocPropsCore(PHPExcel $pPHPExcel = null)
        {
                // Create XML writer
                $objWriter = null;
                if ($this->getParentWriter()->getUseDiskCaching()) {
                        $objWriter = new PHPExcel_Shared_XMLWriter(PHPExcel_Shared_XMLWriter::STORAGE_DISK, $this->getParentWriter()->getDiskCachingDirectory());
                } else {
                        $objWriter = new PHPExcel_Shared_XMLWriter(PHPExcel_Shared_XMLWriter::STORAGE_MEMORY);
                }

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

                // cp:coreProperties
                $objWriter->startElement('cp:coreProperties');
                        $objWriter->writeAttribute('xmlns:cp', 'http://schemas.openxmlformats.org/package/2006/metadata/core-properties');
                        $objWriter->writeAttribute('xmlns:dc', 'http://purl.org/dc/elements/1.1/');
                        $objWriter->writeAttribute('xmlns:dcterms', 'http://purl.org/dc/terms/');
                        $objWriter->writeAttribute('xmlns:dcmitype', 'http://purl.org/dc/dcmitype/');
                        $objWriter->writeAttribute('xmlns:xsi', 'http://www.w3.org/2001/XMLSchema-instance');

                        // dc:creator
                        $objWriter->writeElement('dc:creator',                  $pPHPExcel->getProperties()->getCreator());

                        // cp:lastModifiedBy
                        $objWriter->writeElement('cp:lastModifiedBy',   $pPHPExcel->getProperties()->getLastModifiedBy());

                        // dcterms:created
                        $objWriter->startElement('dcterms:created');
                                $objWriter->writeAttribute('xsi:type', 'dcterms:W3CDTF');
                                $objWriter->writeRawData(date(DATE_W3C,         $pPHPExcel->getProperties()->getCreated()));
                        $objWriter->endElement();

                        // dcterms:modified
                        $objWriter->startElement('dcterms:modified');
                                $objWriter->writeAttribute('xsi:type', 'dcterms:W3CDTF');
                                $objWriter->writeRawData(date(DATE_W3C,         $pPHPExcel->getProperties()->getModified()));
                        $objWriter->endElement();

                        // dc:title
                        $objWriter->writeElement('dc:title',                    $pPHPExcel->getProperties()->getTitle());

                        // dc:description
                        $objWriter->writeElement('dc:description',              $pPHPExcel->getProperties()->getDescription());

                        // dc:subject
                        $objWriter->writeElement('dc:subject',                  $pPHPExcel->getProperties()->getSubject());

                        // cp:keywords
                        $objWriter->writeElement('cp:keywords',                 $pPHPExcel->getProperties()->getKeywords());

                        // cp:category
                        $objWriter->writeElement('cp:category',                 $pPHPExcel->getProperties()->getCategory());

                $objWriter->endElement();

                // Return
                return $objWriter->getData();
        }

        public function writeDocPropsCustom(PHPExcel $pPHPExcel = null)
        {
                $customPropertyList = $pPHPExcel->getProperties()->getCustomProperties();
                if (count($customPropertyList) == 0) {
                        return;
                }

                // Create XML writer
                $objWriter = null;
                if ($this->getParentWriter()->getUseDiskCaching()) {
                        $objWriter = new PHPExcel_Shared_XMLWriter(PHPExcel_Shared_XMLWriter::STORAGE_DISK, $this->getParentWriter()->getDiskCachingDirectory());
                } else {
                        $objWriter = new PHPExcel_Shared_XMLWriter(PHPExcel_Shared_XMLWriter::STORAGE_MEMORY);
                }

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

                // cp:coreProperties
                $objWriter->startElement('Properties');
                        $objWriter->writeAttribute('xmlns', 'http://schemas.openxmlformats.org/officeDocument/2006/custom-properties');
                        $objWriter->writeAttribute('xmlns:vt', 'http://schemas.openxmlformats.org/officeDocument/2006/docPropsVTypes');


                        foreach($customPropertyList as $key => $customProperty) {
                                $propertyValue = $pPHPExcel->getProperties()->getCustomPropertyValue($customProperty);
                                $propertyType = $pPHPExcel->getProperties()->getCustomPropertyType($customProperty);

                                $objWriter->startElement('property');
                                        $objWriter->writeAttribute('fmtid',     '{D5CDD505-2E9C-101B-9397-08002B2CF9AE}');
                                        $objWriter->writeAttribute('pid',               $key+2);
                                        $objWriter->writeAttribute('name',              $customProperty);

                                        switch($propertyType) {
                                                case 'i' :
                                                        $objWriter->writeElement('vt:i4',               $propertyValue);
                                                        break;
                                                case 'f' :
                                                        $objWriter->writeElement('vt:r8',               $propertyValue);
                                                        break;
                                                case 'b' :
                                                        $objWriter->writeElement('vt:bool',     ($propertyValue) ? 'true' : 'false');
                                                        break;
                                                case 'd' :
                                                        $objWriter->startElement('vt:filetime');
                                                                $objWriter->writeRawData(date(DATE_W3C, $propertyValue));
                                                        $objWriter->endElement();
                                                        break;
                                                default :
                                                        $objWriter->writeElement('vt:lpwstr',   $propertyValue);
                                                        break;
                                        }

                                $objWriter->endElement();
                        }


                $objWriter->endElement();

                // Return
                return $objWriter->getData();
        }

}