Vtiful\Kernel\Excel::addSheet
(PHP 7 >= 7.0.0, PECL xlswriter >= 1.2.1)
Vtiful\Kernel\Excel::addSheet — Vtiful\Kernel\Excel addSheet
说明
public
Vtiful\Kernel\Excel::addSheet (
string
$sheetName
)
Create a new worksheet in the xlsx file.
参数
-
sheetName
-
Worksheet name
返回值
Vtiful\Kernel\Excel instance
范例
Example #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();
?>