private function PHPExcel_Writer_Excel2007_Worksheet::_writeHyperlinks in Loft Data Grids 6.2

Same name and namespace in other branches

1. 7.2 vendor/phpoffice/phpexcel/Classes/PHPExcel/Writer/Excel2007/Worksheet.php \PHPExcel_Writer_Excel2007_Worksheet::_writeHyperlinks()

* Write Hyperlinks * *

Parameters

PHPExcel_Shared_XMLWriter $objWriter XML Writer: * @param PHPExcel_Worksheet $pSheet Worksheet * @throws PHPExcel_Writer_Exception

1 call to PHPExcel_Writer_Excel2007_Worksheet::_writeHyperlinks()

PHPExcel_Writer_Excel2007_Worksheet::writeWorksheet in vendor/phpoffice/phpexcel/Classes/PHPExcel/Writer/Excel2007/Worksheet.php

* Write worksheet to XML format * *

File

vendor/phpoffice/phpexcel/Classes/PHPExcel/Writer/Excel2007/Worksheet.php, line 608

Class

PHPExcel_Writer_Excel2007_Worksheet

PHPExcel_Writer_Excel2007_Worksheet

Code

private function _writeHyperlinks(PHPExcel_Shared_XMLWriter $objWriter = null, PHPExcel_Worksheet $pSheet = null) {

  // Hyperlink collection
  $hyperlinkCollection = $pSheet
    ->getHyperlinkCollection();

  // Relation ID
  $relationId = 1;

  // Write hyperlinks?
  if (!empty($hyperlinkCollection)) {
    $objWriter
      ->startElement('hyperlinks');
    foreach ($hyperlinkCollection as $coordinate => $hyperlink) {
      $objWriter
        ->startElement('hyperlink');
      $objWriter
        ->writeAttribute('ref', $coordinate);
      if (!$hyperlink
        ->isInternal()) {
        $objWriter
          ->writeAttribute('r:id', 'rId_hyperlink_' . $relationId);
        ++$relationId;
      }
      else {
        $objWriter
          ->writeAttribute('location', str_replace('sheet://', '', $hyperlink
          ->getUrl()));
      }
      if ($hyperlink
        ->getTooltip() != '') {
        $objWriter
          ->writeAttribute('tooltip', $hyperlink
          ->getTooltip());
      }
      $objWriter
        ->endElement();
    }
    $objWriter
      ->endElement();
  }
}