(PECL xlswriter >= 1.2.1)
Vtiful\Kernel\Excel::setColumn — Vtiful\Kernel\Excel setColumn
$range
, float $width
, resource $format
= ?)Set the format of the column.
range
cell start and end coordinate strings
width
column width
format
cell format resource
Vtiful\Kernel\Excel instance
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]]) ->setColumn('A:A', 200, $boldStyle) ->output();