viliy / xlsx-writer

example2.php

<?php

require __DIR__ . '/vendor/autoload.php';

use Zhaqq\Xlsx\Writer\Builder;

date_default_timezone_set('PRC');

try {
    $writer = new Builder();

    $fileName = __DIR__ . '/data/xlsx_writer' . date('Ymd-His') . '.xlsx';

    $writer->buildHeader('sheet_name_1', [
        'title' => 'string',
        'content' => 'string',
        'weight' => 'number',
    ]);
    $writer->buildHeader('sheet_name_2', [
        'title' => 'string',
        'content' => 'string',
        'price' => 'price',
    ]);

    foreach (rows(10) as $row) {

The call to rows() has too many arguments starting with 10.

        $writer->writeSheetRow($row[0], $row[1]);
    }

    $writer->writeToFile($fileName);

} catch (\Exception $exception) {
    var_dump($exception->getMessage());
}

function rows($n = 10)
{
    for ($i = 0; $i < $n; $i++) {
        if ($i % 2) {
            yield ['sheet_name_1', [
                'title' . $i,
                'content' . $i,
                $i+$i,
            ]];
        } else {
            yield ['sheet_name_2', [
                'title' . $i,
                'content' . $i,
                $i+$i,
            ]];
        }
    }
}