首页 php

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

发布于: 2024-07-10

安装

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");