PHPTS:一键免费搭建 Nginx + PHP + MySQL 运行环境

Vtiful\Kernel\Excel::addSheet

(PHP 7 >= 7.0.0, 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();
?>