Php/docs/vtiful-kernel-excel.addSheet

From Get docs
Revision as of 07:34, 9 December 2020 by Notes (talk | contribs) (autoload)
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)

Vtiful\Kernel\Excel::addSheet

(PECL xlswriter >= 1.2.1)

Vtiful\Kernel\Excel::addSheetVtiful\Kernel\Excel addSheet


Description

public Vtiful\Kernel\Excel::addSheet ( string $sheetName )

Create a new worksheet in the xlsx file.


Parameters

sheetName
Worksheet name


Return Values

Vtiful\Kernel\Excel instance


Examples

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();?>