New file |
0,0 → 1,268 |
<?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_Excel2007 |
* @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_Excel2007_Comments |
* |
* @category PHPExcel |
* @package PHPExcel_Writer_Excel2007 |
* @copyright Copyright (c) 2006 - 2013 PHPExcel (http://www.codeplex.com/PHPExcel) |
*/ |
class PHPExcel_Writer_Excel2007_Comments extends PHPExcel_Writer_Excel2007_WriterPart |
{ |
/** |
* Write comments to XML format |
* |
* @param PHPExcel_Worksheet $pWorksheet |
* @return string XML Output |
* @throws PHPExcel_Writer_Exception |
*/ |
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 through authors |
$objWriter->startElement('authors'); |
foreach ($authors as $author => $index) { |
$objWriter->writeElement('author', $author); |
} |
$objWriter->endElement(); |
|
// Loop through comments |
$objWriter->startElement('commentList'); |
foreach ($comments as $key => $value) { |
$this->_writeComment($objWriter, $key, $value, $authors); |
} |
$objWriter->endElement(); |
|
$objWriter->endElement(); |
|
// Return |
return $objWriter->getData(); |
} |
|
/** |
* Write comment to XML format |
* |
* @param PHPExcel_Shared_XMLWriter $objWriter XML Writer |
* @param string $pCellReference Cell reference |
* @param PHPExcel_Comment $pComment Comment |
* @param array $pAuthors Array of authors |
* @throws PHPExcel_Writer_Exception |
*/ |
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(); |
} |
|
/** |
* Write VML comments to XML format |
* |
* @param PHPExcel_Worksheet $pWorksheet |
* @return string XML Output |
* @throws PHPExcel_Writer_Exception |
*/ |
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 through comments |
foreach ($comments as $key => $value) { |
$this->_writeVMLComment($objWriter, $key, $value); |
} |
|
$objWriter->endElement(); |
|
// Return |
return $objWriter->getData(); |
} |
|
/** |
* Write VML comment to XML format |
* |
* @param PHPExcel_Shared_XMLWriter $objWriter XML Writer |
* @param string $pCellReference Cell reference |
* @param PHPExcel_Comment $pComment Comment |
* @throws PHPExcel_Writer_Exception |
*/ |
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(); |
} |
} |