PHPExcel_Writer_Excel2007_Comments Class Reference

Inheritance diagram for PHPExcel_Writer_Excel2007_Comments:

Collaboration diagram for PHPExcel_Writer_Excel2007_Comments:

Public Member Functions
	writeComments (PHPExcel_Worksheet $pWorksheet=null)
	Write comments to XML format.
	_writeComment (PHPExcel_Shared_XMLWriter $objWriter=null, $pCellReference= 'A1', PHPExcel_Comment $pComment=null, $pAuthors=null)
	Write comment to XML format.
	writeVMLComments (PHPExcel_Worksheet $pWorksheet=null)
	Write VML comments to XML format.
	_writeVMLComment (PHPExcel_Shared_XMLWriter $objWriter=null, $pCellReference= 'A1', PHPExcel_Comment $pComment=null)
	Write VML comment to XML format.
Public Member Functions inherited from PHPExcel_Writer_Excel2007_WriterPart
	setParentWriter (PHPExcel_Writer_IWriter $pWriter=null)
	Set parent IWriter object.
	getParentWriter ()
	Get parent IWriter object.

Detailed Description

Definition at line 72 of file Comments.php.

Member Function Documentation

PHPExcel_Writer_Excel2007_Comments::_writeComment	(	PHPExcel_Shared_XMLWriter	$objWriter = null,
			$pCellReference = 'A1',
		PHPExcel_Comment	$pComment = null,
			$pAuthors = null
	)

Write comment to XML format.

Parameters

PHPExcel_Shared_XMLWriter	$objWriter	XML Writer
string	$pCellReference	Cell reference
PHPExcel_Comment	$pComment	Comment
array	$pAuthors	Array of authors

Exceptions

Exception

Definition at line 139 of file Comments.php.

References PHPExcel_Writer_Excel2007_WriterPart\getParentWriter().

Referenced by writeComments().

        {
                // 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();
        }

Here is the call graph for this function:

Here is the caller graph for this function:

PHPExcel_Writer_Excel2007_Comments::_writeVMLComment	(	PHPExcel_Shared_XMLWriter	$objWriter = null,
			$pCellReference = 'A1',
		PHPExcel_Comment	$pComment = null
	)

Write VML comment to XML format.

Parameters

PHPExcel_Shared_XMLWriter	$objWriter	XML Writer
string	$pCellReference	Cell reference
PHPExcel_Comment	$pComment	Comment

Exceptions

Exception

Definition at line 234 of file Comments.php.

References $row, PHPExcel_Cell\columnIndexFromString(), and PHPExcel_Cell\coordinateFromString().

Referenced by writeVMLComments().

        {
                // 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();
        }

Here is the call graph for this function:

Here is the caller graph for this function:

PHPExcel_Writer_Excel2007_Comments::writeComments

(

PHPExcel_Worksheet

$pWorksheet = null

)

Write comments to XML format.

Parameters

PHPExcel_Worksheet

$pWorksheet

Returns

string XML Output

Exceptions

Exception

Definition at line 81 of file Comments.php.

References $comment, $key, _writeComment(), PHPExcel_Writer_Excel2007_WriterPart\getParentWriter(), PHPExcel_Shared_XMLWriter\STORAGE_DISK, and PHPExcel_Shared_XMLWriter\STORAGE_MEMORY.

        {
                // 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();
        }

Here is the call graph for this function:

PHPExcel_Writer_Excel2007_Comments::writeVMLComments

(

PHPExcel_Worksheet

$pWorksheet = null

)

Write VML comments to XML format.

Parameters

PHPExcel_Worksheet

$pWorksheet

Returns

string XML Output

Exceptions

Exception

Definition at line 161 of file Comments.php.

References $key, _writeVMLComment(), PHPExcel_Writer_Excel2007_WriterPart\getParentWriter(), PHPExcel_Shared_XMLWriter\STORAGE_DISK, and PHPExcel_Shared_XMLWriter\STORAGE_MEMORY.

        {
                // 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();
        }

Here is the call graph for this function:

---

The documentation for this class was generated from the following file:

• Services/Excel/classes/PHPExcel/Writer/Excel2007/Comments.php