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