(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
{
public constMemory
(
string $fileName
[,
string $sheetName
] )
public data
(
array $data
)
public fileName
(
string $fileName
[,
string $sheetName
] )
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 setColumn
(
string $range
,
float $width
[,
resource $format
] )
public setRow
(
string $range
,
float $height
[,
resource $format
] )
}