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.