« リソース型
Vtiful\Kernel\Excel::addSheet »

The Vtiful\Kernel\Excel class

(PECL xlswriter >= 1.2.1)

はじめに

Create xlsx files and set cells and output xlsx files

クラス概要

class Vtiful\Kernel\Excel {
/* メソッド */
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 = ?)
}

目次

関連キーワード:
Vtiful   Kernel   Excel   fileName   addSheet   output   sheetName   autoFilter   constMemory   getHandle   header   insertFormula   column   insertImage   insertText   float   format   mergeCells   setColumn   setRow   xlsx   files   construct   scope   range
関連する関数・ページ:
vtiful-kernel-excel.addSheet   book.xlswriter   vtiful-kernel-excel.filename   vtiful-kernel-excel.autoFilter   vtiful-kernel-excel.output   vtiful-kernel-excel.constMemory