Source for file Rels.php
Documentation is available at Rels.php
* Copyright (c) 2006 - 2011 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
* @package PHPExcel_Writer_Excel2007
* @copyright Copyright (c) 2006 - 2011 PHPExcel (http://www.codeplex.com/PHPExcel)
* @license http://www.gnu.org/licenses/old-licenses/lgpl-2.1.txt LGPL
* @version 1.7.6, 2011-02-27
* PHPExcel_Writer_Excel2007_Rels
* @package PHPExcel_Writer_Excel2007
* @copyright Copyright (c) 2006 - 2011 PHPExcel (http://www.codeplex.com/PHPExcel)
* Write relationships to XML format
* @param PHPExcel $pPHPExcel
* @return string XML Output
$objWriter->startDocument('1.0','UTF-8','yes');
$objWriter->startElement('Relationships');
$objWriter->writeAttribute('xmlns', 'http://schemas.openxmlformats.org/package/2006/relationships');
$customPropertyList = $pPHPExcel->getProperties()->getCustomProperties();
if (count($customPropertyList) > 0) {
// Relationship docProps/app.xml
$this->_writeRelationship(
'http://schemas.openxmlformats.org/officeDocument/2006/relationships/custom-properties',
// Relationship docProps/app.xml
$this->_writeRelationship(
'http://schemas.openxmlformats.org/officeDocument/2006/relationships/extended-properties',
// Relationship docProps/core.xml
$this->_writeRelationship(
'http://schemas.openxmlformats.org/package/2006/relationships/metadata/core-properties',
// Relationship xl/workbook.xml
$this->_writeRelationship(
'http://schemas.openxmlformats.org/officeDocument/2006/relationships/officeDocument',
$objWriter->endElement();
return $objWriter->getData();
* Write workbook relationships to XML format
* @param PHPExcel $pPHPExcel
* @return string XML Output
$objWriter->startDocument('1.0','UTF-8','yes');
$objWriter->startElement('Relationships');
$objWriter->writeAttribute('xmlns', 'http://schemas.openxmlformats.org/package/2006/relationships');
// Relationship styles.xml
$this->_writeRelationship(
'http://schemas.openxmlformats.org/officeDocument/2006/relationships/styles',
// Relationship theme/theme1.xml
$this->_writeRelationship(
'http://schemas.openxmlformats.org/officeDocument/2006/relationships/theme',
// Relationship sharedStrings.xml
$this->_writeRelationship(
'http://schemas.openxmlformats.org/officeDocument/2006/relationships/sharedStrings',
// Relationships with sheets
$sheetCount = $pPHPExcel->getSheetCount();
for ($i = 0; $i < $sheetCount; ++ $i) {
$this->_writeRelationship(
'http://schemas.openxmlformats.org/officeDocument/2006/relationships/worksheet',
'worksheets/sheet' . ($i + 1) . '.xml'
$objWriter->endElement();
return $objWriter->getData();
* Write worksheet relationships to XML format
* Numbering is as follows:
* rId_hyperlink_x - Hyperlinks
* @param PHPExcel_Worksheet $pWorksheet
* @param int $pWorksheetId
* @return string XML Output
$objWriter->startDocument('1.0','UTF-8','yes');
$objWriter->startElement('Relationships');
$objWriter->writeAttribute('xmlns', 'http://schemas.openxmlformats.org/package/2006/relationships');
// Write drawing relationships?
if ($pWorksheet->getDrawingCollection()->count() > 0) {
$this->_writeRelationship(
'http://schemas.openxmlformats.org/officeDocument/2006/relationships/drawing',
'../drawings/drawing' . $pWorksheetId . '.xml'
// Write hyperlink relationships?
foreach ($pWorksheet->getHyperlinkCollection() as $hyperlink) {
if (!$hyperlink->isInternal()) {
$this->_writeRelationship(
'http://schemas.openxmlformats.org/officeDocument/2006/relationships/hyperlink',
// Write comments relationship?
if (count($pWorksheet->getComments()) > 0) {
$this->_writeRelationship(
'http://schemas.openxmlformats.org/officeDocument/2006/relationships/vmlDrawing',
'../drawings/vmlDrawing' . $pWorksheetId . '.vml'
$this->_writeRelationship(
'http://schemas.openxmlformats.org/officeDocument/2006/relationships/comments',
'../comments' . $pWorksheetId . '.xml'
// Write header/footer relationship?
if (count($pWorksheet->getHeaderFooter()->getImages()) > 0) {
$this->_writeRelationship(
'_headerfooter_vml' . $i,
'http://schemas.openxmlformats.org/officeDocument/2006/relationships/vmlDrawing',
'../drawings/vmlDrawingHF' . $pWorksheetId . '.vml'
$objWriter->endElement();
return $objWriter->getData();
* Write drawing relationships to XML format
* @param PHPExcel_Worksheet $pWorksheet
* @return string XML Output
$objWriter->startDocument('1.0','UTF-8','yes');
$objWriter->startElement('Relationships');
$objWriter->writeAttribute('xmlns', 'http://schemas.openxmlformats.org/package/2006/relationships');
// Loop through images and write relationships
$iterator = $pWorksheet->getDrawingCollection()->getIterator();
while ($iterator->valid()) {
// Write relationship for image drawing
$this->_writeRelationship(
'http://schemas.openxmlformats.org/officeDocument/2006/relationships/image',
'../media/' . str_replace(' ', '', $iterator->current()->getIndexedFilename())
$objWriter->endElement();
return $objWriter->getData();
* Write header/footer drawing relationships to XML format
* @param PHPExcel_Worksheet $pWorksheet
* @return string XML Output
$objWriter->startDocument('1.0','UTF-8','yes');
$objWriter->startElement('Relationships');
$objWriter->writeAttribute('xmlns', 'http://schemas.openxmlformats.org/package/2006/relationships');
// Loop through images and write relationships
foreach ($pWorksheet->getHeaderFooter()->getImages() as $key => $value) {
// Write relationship for image drawing
$this->_writeRelationship(
'http://schemas.openxmlformats.org/officeDocument/2006/relationships/image',
'../media/' . $value->getIndexedFilename()
$objWriter->endElement();
return $objWriter->getData();
* Write Override content type
* @param PHPExcel_Shared_XMLWriter $objWriter XML Writer
* @param int $pId Relationship ID. rId will be prepended!
* @param string $pType Relationship type
* @param string $pTarget Relationship target
* @param string $pTargetMode Relationship target mode
private function _writeRelationship(PHPExcel_Shared_XMLWriter $objWriter = null, $pId = 1, $pType = '', $pTarget = '', $pTargetMode = '')
if ($pType != '' && $pTarget != '') {
$objWriter->startElement('Relationship');
$objWriter->writeAttribute('Id', 'rId' . $pId);
$objWriter->writeAttribute('Type', $pType);
$objWriter->writeAttribute('Target', $pTarget);
if ($pTargetMode != '') {
$objWriter->writeAttribute('TargetMode', $pTargetMode);
$objWriter->endElement();
throw new Exception("Invalid parameters passed.");
|