Php/docs/class.vtiful-kernel-excel
(PECL xlswriter >= 1.2.1)
Introduction
Create xlsx files and set cells and output xlsx files
Class synopsis
Vtiful\Kernel\Excel {
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 ( )
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 ( )
public setColumn
( string $range
, float $width
[, resource $format
] )
public setRow
( string $range
, float $height
[, resource $format
] )
}
Table of Contents
- Vtiful\Kernel\Excel::addSheet — Vtiful\Kernel\Excel addSheet
- Vtiful\Kernel\Excel::autoFilter — Vtiful\Kernel\Excel autoFilter
- Vtiful\Kernel\Excel::constMemory — Vtiful\Kernel\Excel constMemory
- Vtiful\Kernel\Excel::__construct — Vtiful\Kernel\Excel constructor
- Vtiful\Kernel\Excel::data — Vtiful\Kernel\Excel data
- Vtiful\Kernel\Excel::fileName — Vtiful\Kernel\Excel fileName
- Vtiful\Kernel\Excel::getHandle — Vtiful\Kernel\Excel getHandle
- Vtiful\Kernel\Excel::header — Vtiful\Kernel\Excel header
- Vtiful\Kernel\Excel::insertFormula — Vtiful\Kernel\Excel insertFormula
- Vtiful\Kernel\Excel::insertImage — Vtiful\Kernel\Excel insertImage
- Vtiful\Kernel\Excel::insertText — Vtiful\Kernel\Excel insertText
- Vtiful\Kernel\Excel::mergeCells — Vtiful\Kernel\Excel mergeCells
- Vtiful\Kernel\Excel::output — Vtiful\Kernel\Excel output
- Vtiful\Kernel\Excel::setColumn — Vtiful\Kernel\Excel setColumn
- Vtiful\Kernel\Excel::setRow — Vtiful\Kernel\Excel setRow
/* Methods */