(PECL xlswriter >= 1.2.1)
Vtiful\Kernel\Excel::addSheet — Vtiful\Kernel\Excel addSheet
Create a new worksheet in the xlsx file.
sheetName
Worksheet name
Vtiful\Kernel\Excel instance
Exemplo #1 example
<?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();
?>