Edit Report a Bug

    Vtiful\Kernel\Excel::addSheet

    (PECL xlswriter >= 1.2.1)

    Vtiful\Kernel\Excel::addSheet — Vtiful\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

    示例

    示例 #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();
    ?>
    add a note add a note

    User Contributed Notes

    There are no user contributed notes for this page.
    To Top