private function PHPExcel_Writer_Excel2007_Worksheet::_writeHyperlinks in Loft Data Grids 7.2
Same name and namespace in other branches
- 6.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();
}
}