使用`maatwebsite/excel`进行表格操作

2024-07-10 php excel

安装

1
composer require maatwebsite/excel ^3.1

导出

  1. 定义导出类
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
use App\Exports\Sheets\TeamRegistration\Enterprise;
use App\Exports\Sheets\TeamRegistration\School;
use Maatwebsite\Excel\Concerns\Exportable;
use Maatwebsite\Excel\Concerns\WithMultipleSheets;

class TestSheets implements WithMultipleSheets
{
    use Exportable;

    public function sheets(): array
    {
        $sheets = [];
        //Sheet1
        $sheets[] = new Sheet1();
        //Sheet2
				//$sheets[] = new Sheet1();
        return $sheets;
    }
}
  1. 定义第1个sheets
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
use Maatwebsite\Excel\Concerns\FromArray;
use Maatwebsite\Excel\Concerns\WithHeadings;
use Maatwebsite\Excel\Concerns\WithTitle;

class Sheet1 implements FromArray, WithHeadings, WithTitle
{
    public function array(): array
    {
        $list[0]['h1'] = 'h11';
        $list[0]['h2'] = 'h22';
        $list[0]['h3'] = 'h33';
        return  $list;
    }
    public function headings(): array
    {
        return  ["h1","h2","h3"];
    }

    public function title(): string
    {
        return "sheet1";
    }
}
  1. 使用
1
return (new TestSheets())->download("test-name.xlsx");