PHP 8.1.31 Released!

    The Vtiful\Kernel\Excel class

    (PECL xlswriter >= 1.2.1)

    Introduction

    Create xlsx files and set cells and output xlsx files

    Class synopsis

    class Vtiful\Kernel\Excel {
    /* Methods */
    public __construct(array $config)
    public addSheet(string $sheetName)
    public autoFilter(string $scope)
    public constMemory(string $fileName, string $sheetName = ?)
    public data(array $data)
    public fileName(string $fileName, string $sheetName = ?)
    public getHandle()
    public header(array $headerData)
    public insertFormula(int $row, int $column, string $formula)
    public insertImage(int $row, int $column, string $localImagePath)
    public insertText(
        int $row,
        int $column,
        int|float|string $data,
        string $format = ?
    )
    public mergeCells(string $scope, string $data)
    public output()
    public setColumn(string $range, float $width, resource $format = ?)
    public setRow(string $range, float $height, resource $format = ?)
    }

    Table of Contents

    Improve This Page

    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