Php/docs/vtiful-kernel-excel.addSheet

来自菜鸟教程
跳转至:导航、​搜索

Vtiful\Kernel\Excel::addSheet

(PECL xlswriter >= 1.2.1)

Vtiful\Kernel\Excel::addSheetVtiful\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();?>