Vtiful\Kernel\Excel::setColumn
(PHP 7 >= 7.0.0, PECL xlswriter >= 1.2.1)
Vtiful\Kernel\Excel::setColumn — Vtiful\Kernel\Excel setColumn
说明
public Vtiful\Kernel\Excel::setColumn
( string
$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();