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

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 ] )

}