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

Insert text

Insert formula

Last modified 3yr ago