Vtiful\Kernel\Excel::setColumn

(PECL xlswriter >= 1.2.1)

Vtiful\Kernel\Excel::setColumn — Vtiful\Kernel\Excel setColumn

説明

public function 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 setColumn example

<?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();

関連キーワード:

Vtiful Kernel Excel setColumn format excel width output range resource column cell config boldStyle setRow xlswriter float start coordinate strings instance example path tests fileName