Worksheet::writeUrl

Worksheet::writeUrl – Write a hyperlink. This is comprised of two elements: the visible label and

Synopsis

require_once "Spreadsheet/Excel/Writer.php";

void Worksheet::writeUrl ( integer $row , integer $col , string $url , string $string='' , mixed $format=0 )

Description

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() method. Therefore the 255 characters string limit applies. $string and $format are optional and their order is interchangeable. The hyperlink can be to a http, ftp, mail, internal sheet, or external directory url. Returns 0 : normal termination -1 : insufficient number of arguments -2 : row or column out of range -3 : long string truncated to 255 chars

Parameter

  • integer $row - Row

  • integer $col - Column

  • string $url - URL string

  • string $string - Alternative label

  • mixed $format - The cell format

Note

This function can not be called statically.

Example

Using writeUrl()

<?php

?>