Comments.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/Writer/Excel2007.php';

require_once PHPEXCEL_ROOT . 'PHPExcel/Writer/Excel2007/WriterPart.php';

require_once PHPEXCEL_ROOT . 'PHPExcel/Worksheet.php';

require_once PHPEXCEL_ROOT . 'PHPExcel/Comment.php';

require_once PHPEXCEL_ROOT . 'PHPExcel/RichText.php';

require_once PHPEXCEL_ROOT . 'PHPExcel/Cell.php';

require_once PHPEXCEL_ROOT . 'PHPExcel/Style/Color.php';

require_once PHPEXCEL_ROOT . 'PHPExcel/Shared/XMLWriter.php';


class PHPExcel_Writer_Excel2007_Comments extends PHPExcel_Writer_Excel2007_WriterPart
{
        public function writeComments(PHPExcel_Worksheet $pWorksheet = 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');
  
                // Comments cache
                $comments       = $pWorksheet->getComments();
                
                // Authors cache
                $authors        = array();
                $authorId       = 0;
                foreach ($comments as $comment) {
                        if (!isset($authors[$comment->getAuthor()])) {
                                $authors[$comment->getAuthor()] = $authorId++;
                        }
                }
  
                // comments
                $objWriter->startElement('comments');
                $objWriter->writeAttribute('xmlns', 'http://schemas.openxmlformats.org/spreadsheetml/2006/main');
                        
                        // Loop trough authors
                        $objWriter->startElement('authors');
                        foreach ($authors as $author => $index) {
                                $objWriter->writeElement('author', $author);
                        }
                        $objWriter->endElement();
                        
                        // Loop trough comments
                        $objWriter->startElement('commentList');
                        foreach ($comments as $key => $value) {
                                $this->_writeComment($objWriter, $key, $value, $authors);
                        }
                        $objWriter->endElement();
                                
                $objWriter->endElement();

                // Return
                return $objWriter->getData();
        }
        
        public function _writeComment(PHPExcel_Shared_XMLWriter $objWriter = null, $pCellReference = 'A1', PHPExcel_Comment $pComment = null, $pAuthors = null)
        {
                // comment
                $objWriter->startElement('comment');
                $objWriter->writeAttribute('ref',               $pCellReference);
                $objWriter->writeAttribute('authorId',  $pAuthors[$pComment->getAuthor()]);
                
                        // text
                        $objWriter->startElement('text');
                        $this->getParentWriter()->getWriterPart('stringtable')->writeRichText($objWriter, $pComment->getText());
                        $objWriter->endElement();
                
                $objWriter->endElement();
        }
        
        public function writeVMLComments(PHPExcel_Worksheet $pWorksheet = 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');
  
                // Comments cache
                $comments       = $pWorksheet->getComments();
 
                // xml
                $objWriter->startElement('xml');
                $objWriter->writeAttribute('xmlns:v', 'urn:schemas-microsoft-com:vml');
                $objWriter->writeAttribute('xmlns:o', 'urn:schemas-microsoft-com:office:office');
                $objWriter->writeAttribute('xmlns:x', 'urn:schemas-microsoft-com:office:excel');

                        // o:shapelayout
                        $objWriter->startElement('o:shapelayout');
                        $objWriter->writeAttribute('v:ext',             'edit');
                        
                                // o:idmap
                                $objWriter->startElement('o:idmap');
                                $objWriter->writeAttribute('v:ext',     'edit');
                                $objWriter->writeAttribute('data',              '1');
                                $objWriter->endElement();
                        
                        $objWriter->endElement();
                        
                        // v:shapetype
                        $objWriter->startElement('v:shapetype');
                        $objWriter->writeAttribute('id',                '_x0000_t202');
                        $objWriter->writeAttribute('coordsize', '21600,21600');
                        $objWriter->writeAttribute('o:spt',     '202');
                        $objWriter->writeAttribute('path',              'm,l,21600r21600,l21600,xe');
                        
                                // v:stroke
                                $objWriter->startElement('v:stroke');
                                $objWriter->writeAttribute('joinstyle',         'miter');
                                $objWriter->endElement();
                                
                                // v:path
                                $objWriter->startElement('v:path');
                                $objWriter->writeAttribute('gradientshapeok',   't');
                                $objWriter->writeAttribute('o:connecttype',     'rect');
                                $objWriter->endElement();
                        
                        $objWriter->endElement();
                
                        // Loop trough comments
                        foreach ($comments as $key => $value) {
                                $this->_writeVMLComment($objWriter, $key, $value);
                        }
                                
                $objWriter->endElement();

                // Return
                return $objWriter->getData();
        }
        
        public function _writeVMLComment(PHPExcel_Shared_XMLWriter $objWriter = null, $pCellReference = 'A1', PHPExcel_Comment $pComment = null)
        {
                // Metadata
                list($column, $row) = PHPExcel_Cell::coordinateFromString($pCellReference);
                $column = PHPExcel_Cell::columnIndexFromString($column);
                $id = 1024 + $column + $row;
                $id = substr($id, 0, 4);
                
                // v:shape
                $objWriter->startElement('v:shape');
                $objWriter->writeAttribute('id',                        '_x0000_s' . $id);
                $objWriter->writeAttribute('type',                      '#_x0000_t202');
                $objWriter->writeAttribute('style',             'position:absolute;margin-left:' . $pComment->getMarginLeft() . ';margin-top:' . $pComment->getMarginTop() . ';width:' . $pComment->getWidth() . ';height:' . $pComment->getHeight() . ';z-index:1;visibility:' . ($pComment->getVisible() ? 'visible' : 'hidden'));
                $objWriter->writeAttribute('fillcolor',         '#' . $pComment->getFillColor()->getRGB());
                $objWriter->writeAttribute('o:insetmode',       'auto');
                
                        // v:fill
                        $objWriter->startElement('v:fill');
                        $objWriter->writeAttribute('color2',            '#' . $pComment->getFillColor()->getRGB());
                        $objWriter->endElement();
                        
                        // v:shadow
                        $objWriter->startElement('v:shadow');
                        $objWriter->writeAttribute('on',                        't');
                        $objWriter->writeAttribute('color',             'black');
                        $objWriter->writeAttribute('obscured',          't');
                        $objWriter->endElement();
                
                        // v:path
                        $objWriter->startElement('v:path');
                        $objWriter->writeAttribute('o:connecttype', 'none');
                        $objWriter->endElement();
                        
                        // v:textbox
                        $objWriter->startElement('v:textbox');
                        $objWriter->writeAttribute('style', 'mso-direction-alt:auto');
                        
                                // div
                                $objWriter->startElement('div');
                                $objWriter->writeAttribute('style', 'text-align:left');
                                $objWriter->endElement();
                        
                        $objWriter->endElement();
                        
                        // x:ClientData
                        $objWriter->startElement('x:ClientData');
                        $objWriter->writeAttribute('ObjectType', 'Note');
                        
                                // x:MoveWithCells
                                $objWriter->writeElement('x:MoveWithCells', '');
                                
                                // x:SizeWithCells
                                $objWriter->writeElement('x:SizeWithCells', '');
                                
                                // x:Anchor
                                //$objWriter->writeElement('x:Anchor', $column . ', 15, ' . ($row - 2) . ', 10, ' . ($column + 4) . ', 15, ' . ($row + 5) . ', 18');

                                // x:AutoFill
                                $objWriter->writeElement('x:AutoFill', 'False');
                                
                                // x:Row
                                $objWriter->writeElement('x:Row', ($row - 1));
                                
                                // x:Column
                                $objWriter->writeElement('x:Column', ($column - 1));
                        
                        $objWriter->endElement();  
                
                $objWriter->endElement();
        }
}