thinkphp excel导入导出

<?php
namespace app\index\controller;

use think\Controller;
use think\facade\Request;
use think\facade\Validate;
use PhpOffice\PhpSpreadsheet\IOFactory;

class ExcelController extends Controller
{
    public function import()
    {
        $file = Request::file('file');
        if (!$file) {
            return json(['code' => 0, 'msg' => '请选择文件']);
        }

        $spreadsheet = IOFactory::load($file);
        $sheetData = $spreadsheet->getActiveSheet()->toArray();

        // 数据验证
        $validate = Validate::make([
            'data.*.name' => 'require',
            'data.*.age'  => 'require|integer',
        ]);

        if (!$validate->check(['data' => $sheetData])) {
            return json(['code' => 0, 'msg' => $validate->getError()]);
        }

        // 数据导入数据库
        $model = model('User');
        foreach ($sheetData as $data) {
            $model->save($data);
        }

        return json(['code' => 1, 'msg' => '导入成功']);
    }
}

<?php
namespace app\index\controller;

use think\Controller;
use think\facade\Db;
use PhpOffice\PhpSpreadsheet\IOFactory;
use PhpOffice\PhpSpreadsheet\Spreadsheet;

class ExcelController extends Controller
{
    public function export()
    {
        $data = Db::name('user')->select();

        $spreadsheet = new Spreadsheet();
        $sheet = $spreadsheet->getActiveSheet();
        $sheet->setCellValue('A1', '姓名');
        $sheet->setCellValue('B1', '年龄');

        $row = 2;
        foreach ($data as $item) {
            $sheet->setCellValue('A' . $row, $item['name']);
            $sheet->setCellValue('B' . $row, $item['age']);
            $row++;
        }

        header('Content-Type: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet');
        header('Content-Disposition: attachment;filename="users.xlsx"');
        header('Cache-Control: max-age=0');

        $writer = IOFactory::createWriter($spreadsheet, 'Xlsx');
        $writer->save('php://output');
    }
}

ini_set('memory_limit', '2048M');