Vtiful\Kernel\Excel::addSheet
PHP function
Edit on GitHub ✎
(PECL xlswriter >= 1.2.1)
Vtiful\Kernel\Excel addSheet
Description
Vtiful\Kernel\Excel::addSheet(string $sheetName)
Create a new worksheet in the xlsx file.
Parameters
sheetNameWorksheet name
Return Values
Vtiful\Kernel\Excel instance
Examples
example
php
<?php
$config = [
'path' => './tests'
];
$fileObject = new \Vtiful\Kernel\Excel($config);
$file = $fileObject->fileName('tutorial.xlsx', 'sheet_one')
->header(['name', 'age'])
->data([
['viest', 23],
['wjx', 23]
]);
$file->addSheet('sheet_two')
->header(['name', 'age'])
->data([
['james', 33],
['king', 33]
]);
$file->output();
?>