function PHPExcel_Writer_Excel5_Worksheet::_writeUrlRange in Loft Data Grids 7.2

Same name and namespace in other branches

1. 6.2 vendor/phpoffice/phpexcel/Classes/PHPExcel/Writer/Excel5/Worksheet.php \PHPExcel_Writer_Excel5_Worksheet::_writeUrlRange()

* This is the more general form of _writeUrl(). It allows a hyperlink to be * written to a range of cells. This function also decides the type of hyperlink * to be written. These are either, Web (http, ftp, mailto), Internal * (Sheet1!A1) or external ('c:\temp\foo.xls#Sheet1!A1'). * * @access private * *

Parameters

integer $row1 Start row: * @param integer $col1 Start column * @param integer $row2 End row * @param integer $col2 End column * @param string $url URL string * @return integer

See also

_writeUrl()

1 call to PHPExcel_Writer_Excel5_Worksheet::_writeUrlRange()

PHPExcel_Writer_Excel5_Worksheet::_writeUrl in vendor/phpoffice/phpexcel/Classes/PHPExcel/Writer/Excel5/Worksheet.php

* Write a hyperlink. * This is comprised of two elements: the visible label and * the invisible link. The visible label is the same as the link unless an * alternative string is specified. The label is written using the * _writeString()…

File

vendor/phpoffice/phpexcel/Classes/PHPExcel/Writer/Excel5/Worksheet.php, line 1000

Class

PHPExcel_Writer_Excel5_Worksheet

PHPExcel_Writer_Excel5_Worksheet

Code

function _writeUrlRange($row1, $col1, $row2, $col2, $url) {

  // Check for internal/external sheet links or default to web link
  if (preg_match('[^internal:]', $url)) {
    return $this
      ->_writeUrlInternal($row1, $col1, $row2, $col2, $url);
  }
  if (preg_match('[^external:]', $url)) {
    return $this
      ->_writeUrlExternal($row1, $col1, $row2, $col2, $url);
  }
  return $this
    ->_writeUrlWeb($row1, $col1, $row2, $col2, $url);
}