Vtiful\Kernel\Excel::setColumn
PHP function
Edit on GitHub ✎
(PECL xlswriter >= 1.2.1)
Vtiful\Kernel\Excel setColumn
Description
Vtiful\Kernel\Excel::setColumn(string $range, float $width, [resource $format])
Set the format of the column.
Parameters
rangecell start and end coordinate strings
widthcolumn width
formatcell format resource
Return Values
Vtiful\Kernel\Excel instance
Examples
setColumn example
php
<?php
$config = [
'path' => './tests'
];
$excel = new \Vtiful\Kernel\Excel($config);
$excel->fileName('tutorial01.xlsx');
$format = new \Vtiful\Kernel\Format($excel->getHandle());
$boldStyle = $format->bold()->toResource();
$excel->header(['name', 'age'])
->data([['viest', 21]])
->setColumn('A:A', 200, $boldStyle)
->output();