The Vtiful\Kernel\Excel class

(PECL xlswriter >= 1.2.1)

Introduction

Create xlsx files and set cells and output xlsx files

class Vtiful\Kernel\Excel {

/* Methods */

public function __construct(array $config)

public function addSheet(string $sheetName)

public function autoFilter(string $scope)

public function constMemory(string $fileName, string $sheetName = ?)

public function data(array $data)

public function fileName(string $fileName, string $sheetName = ?)

public function getHandle()

public function header(array $headerData)

public function insertFormula(int $row, int $column, string $formula)

public function insertImage(int $row, int $column, string $localImagePath)

public function insertText(
    int $row,
    int $column,
    int|float|string $data,
    string $format = ?
)

public function mergeCells(string $scope, string $data)

public function output()

public function setColumn(string $range, float $width, resource $format = ?)

public function setRow(string $range, float $height, resource $format = ?)

}

There are no user contributed notes for this page.