Vtiful\Kernel\Excel::setColumn

(PECL xlswriter >= 1.2.1)

Vtiful\Kernel\Excel::setColumnVtiful\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

例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();
関連キーワード:  Vtiful, Kernel, setColumn, format, width, range, resource, string, public, float