The Vtiful\Kernel\Excel class

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

Introduction

Create xlsx files and set cells and output xlsx files

Class synopsis

Vtiful\Kernel\Excel {
/* Methods */
public addSheet ( string $sheetName )
public autoFilter ( string $scope )
public constMemory ( string $fileName [, string $sheetName ] )
public __construct ( array $config )
public data ( array $data )
public fileName ( string $fileName [, string $sheetName ] )
public getHandle ( void )
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 , stringintdouble $data [, string $format ] )
public mergeCells ( string $scope , string $data )
public output ( void )
public setColumn ( string $range , float $width [, resource $format ] )
public setRow ( string $range , float $height [, resource $format ] )
}

Table of Contents