Vtiful\Kernel\Excel::setRow

Vtiful\Kernel\Excel setRow

Description

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

Set the format of the row.

Parameters

range

cell start and end coordinate strings

height

row height

format

cell format resource

Return Values

Vtiful\Kernel\Excel instance

Examples

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