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();