Vtiful\Kernel\Excel::setRow

(PHP 7 >= 7.0.0, PECL xlswriter >= 1.2.1)

Vtiful\Kernel\Excel::setRow — Vtiful\Kernel\Excel setRow

Descrierea

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

Set the format of the column.

Parametri

range: cell start and end coordinate strings
height: row height
format: cell format resource

Valorile întoarse

Vtiful\Kernel\Excel instance

Exemple

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