array ( 0 => 'index.php', 1 => 'PHP Manual', ), 'head' => array ( 0 => 'UTF-8', 1 => 'es', ), 'this' => array ( 0 => 'vtiful-kernel-excel.addSheet.php', 1 => 'Vtiful\\Kernel\\Excel::addSheet', ), 'up' => array ( 0 => 'class.vtiful-kernel-excel.php', 1 => 'Vtiful\\Kernel\\Excel', ), 'prev' => array ( 0 => 'class.vtiful-kernel-excel.php', 1 => 'Vtiful\\Kernel\\Excel', ), 'next' => array ( 0 => 'vtiful-kernel-excel.autoFilter.php', 1 => 'Vtiful\\Kernel\\Excel::autoFilter', ), 'alternatives' => array ( ), 'source' => array ( 'lang' => 'es', 'path' => 'reference/xlswriter/xlsx-kernel/add-sheet.xml', ), ); $setup["toc"] = $TOC; $setup["toc_deprecated"] = $TOC_DEPRECATED; $setup["parents"] = $PARENTS; manual_setup($setup); ?>
(PECL xlswriter >= 1.2.1)
Vtiful\Kernel\Excel::addSheet — Vtiful\Kernel\Excel addSheet
Crea una nueva hoja de trabajo en el archivo xlsx.
sheetName
Nombre de la hoja de trabajo
instancia Vtiful\Kernel\Excel
Ejemplo #1 ejemplo
<?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();
?>