PHPのお勉強！

PHP TOP
PHP 8.4.2 Released!

    Vtiful\Kernel\Excel::insertFormula

    (PECL xlswriter >= 1.2.1)

    Vtiful\Kernel\Excel::insertFormula — Vtiful\Kernel\Excel insertFormula

    説明

    public Vtiful\Kernel\Excel::insertFormula(int $row, int $column, string $formula)

    Insert calculation formula.

    パラメータ

    row

    cell row

    column

    cell column

    formula

    formula string

    戻り値

    Vtiful\Kernel\Excel instance

    例

    例1 example

    <?php
    $config     = [
    'path' => './tests'
    ];

    $excel = new \Vtiful\Kernel\Excel($config);

    $file = $excel->fileName("free.xlsx")
    ->    header(['name', 'money']);

    for(    $index = 1; $index < 10; $index++) {
    $file->insertText($index, 0, 'viest');
    $file->insertText($index, 1, 10);
    }

    $file->insertText(12, 0, "Total");
    $file->insertFormula(12, 1, '=SUM(B2:B11)'); // insert formula

    $file->output();

    Found A Problem?

    Learn How To Improve This Page • Submit a Pull Request • Report a Bug
    ＋add a note

    User Contributed Notes

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