Vtiful\Kernel\Excel::setRow
(PECL xlswriter >= 1.2.1)
Vtiful\Kernel\Excel::setRow — Vtiful\Kernel\Excel setRow
Description
$range
, float $height
, resource $format
= ?)Set the format of the column.
Parameters
-
range
-
cell start and end coordinate strings
-
height
-
row height
-
format
-
cell format resource
Return Values
Vtiful\Kernel\Excel instance
Examples
Example #1 example
<?php
$config = [
'path' => './tests'
];
$excel = new \Vtiful\Kernel\Excel($config);
$fileObject = $excel->fileName('tutorial01.xlsx');
$fileHandle = $fileObject->getHandle();
$boldStyle = \Vtiful\Kernel\Format::bold($fileHandle);
$fileObject->header(['name', 'age'])
->data([['viest', 21]])
->setRow('A1', 20, $boldStyle,)
->output();