array ( 0 => 'index.php', 1 => 'PHP Manual', ), 'head' => array ( 0 => 'UTF-8', 1 => 'es', ), 'this' => array ( 0 => 'class.vtiful-kernel-excel.php', 1 => 'Vtiful\\Kernel\\Excel', 2 => 'The Vtiful\\Kernel\\Excel class', ), 'up' => array ( 0 => 'book.xlswriter.php', 1 => 'XLSWriter', ), 'prev' => array ( 0 => 'xlswriter.resources.php', 1 => 'Tipos de recursos', ), 'next' => array ( 0 => 'vtiful-kernel-excel.addSheet.php', 1 => 'Vtiful\\Kernel\\Excel::addSheet', ), 'alternatives' => array ( ), 'source' => array ( 'lang' => 'es', 'path' => 'reference/xlswriter/xlsx-kernel.xml', ), 'history' => array ( ), 'extra_header_links' => array ( 'rel' => 'alternate', 'href' => '/manual/en/feeds/class.vtiful-kernel-excel.atom', 'type' => 'application/atom+xml', ), ); $setup["toc"] = $TOC; $setup["toc_deprecated"] = $TOC_DEPRECATED; $setup["parents"] = $PARENTS; manual_setup($setup); contributors($setup); ?>

The Vtiful\Kernel\Excel class

(PECL xlswriter >= 1.2.1)

Introducción

Crea archivos xlsx y fija las celdas y produce los archivos xlsx

Sinopsis de la Clase

class Vtiful\Kernel\Excel {
/* Métodos */
public __construct(array $config)
public addSheet(string $sheetName)
public autoFilter(string $scope)
public constMemory(string $fileName, string $sheetName = ?)
public data(array $data)
public fileName(string $fileName, string $sheetName = ?)
public getHandle()
public header(array $headerData)
public insertFormula(int $row, int $column, string $formula)
public insertImage(int $row, int $column, string $localImagePath)
public insertText(
    int $row,
    int $column,
    int|float|string $data,
    string $format = ?
)
public mergeCells(string $scope, string $data)
public output()
public setColumn(string $range, float $width, resource $format = ?)
public setRow(string $range, float $height, resource $format = ?)
}

Tabla de contenidos