ohffs/simple-spout

基本电子表格导入/导出

维护者

详细信息

github.com/ohnotnow/simple-spout

源代码

问题

安装次数: 3,288

依赖者: 1

建议者: 0

安全性: 0

星标: 2

关注者: 3

分支: 0

公开问题: 0

1.3.0 2021-09-02 10:42 UTC

Requires

Requires (Dev)

MIT 12eec61f4fc75df4418b3af11dbdcc9882094ae3

  • Billy Bofh <billybofh.woop@gmail.com>

This package is auto-updated.

Last update: 2024-08-29 04:31:23 UTC

README

这只是一个围绕'Spout'（https://github.com/box/spout）的基本包装。它可以读取电子表格并将其转换为PHP数组，也可以将PHP数组转换为Excel文件。

安装

只需执行composer require ohffs/simple-spout。

使用方法

<?php

namespace App\Whatever;

use Ohffs\SimpleSpout\ExcelSheet;

class Thing
{
    public function something()
    {
	    // plain import to array
        $data = (new ExcelSheet)->import('/tmp/spreadsheet.xlsx');
        ...;
	    // if you want each cell to have whitespace trimmed from the beginning/end
	    $data = (new ExcelSheet)->trimmedImport('/tmp/spreadsheet.xlsx');

        // import just the very first sheet
        $data = (new ExcelSheet)->importFirst('/tmp/spreadsheet.xlsx');

        // import a specific sheet
        $data = (new ExcelSheet)->importSheet('/tmp/spreadsheet.xlsx', 3); // 0-indexed

        // import the 'active' sheet (ie, the one that was open when the file was saved)
        $data = (new ExcelSheet)->importActive('/tmp/spreadsheet.xlsx');
    }

    public function somethingElse()
    {
        $data = [
          ['smith', 'sarah-jane', 'companion'],
          ['baker', 'tom', 'doctor'],
        ];
        $filename = (new ExcelSheet)->generate($data);
        // or
        (new ExcelSheet)->generate($data, '/data/spreadsheet.xlsx');
    }
}