Insert link

Function Prototype

insertUrl(int $row, int $column, string $url[, resource $formatHandler])

int $row

cell row

int $column

cell column

string $url

link address

resource $formatHandler

cell style

example

$excel = new \Vtiful\Kernel\Excel($config);

$urlFile = $excel->fileName("free.xlsx")
     ->header(['url']);

$fileHandle = $fileObject->getHandle();

$format   = new \Vtiful\Kernel\Format($fileHandle);
$urlStyle = $format->bold()
     ->underline(Format::UNDERLINE_SINGLE)
     ->toResource();

$urlFile->insertUrl(1, 0, 'https://github.com', $urlStyle);

$textFile->output();