Vtiful\Kernel\Excel::setColumn

(PECL xlswriter >= 1.2.1)

Vtiful\Kernel\Excel::setColumnVtiful\Kernel\Excel setColumn

Description

public Vtiful\Kernel\Excel::setColumn(string $range, float $width, resource $format = ?)

Set the format of the column.

Parameters

range

cell start and end coordinate strings

width

column width

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]])    ->setColumn('A:A', 200, $boldStyle)    ->output();