Vtiful\Kernel\Excel::setRow

(PECL xlswriter >= 1.2.1)

Vtiful\Kernel\Excel::setRowVtiful\Kernel\Excel setRow

Description

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

Set the format of the column.

Parameters

range

cell start and end coordinate strings

height

row height

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]])
->
setRow('A1', 20, $boldStyle,)
->
output();