CakeFest 2024: The Official CakePHP Conference

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

User Contributed Notes

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