如何使用Webman框架实现Excel导入导出？

composer require phpoffice/phpspreadsheet

<?php
/**
 * @desc Excel 导入操作
 * @author Tinywan(ShaoBo Wan)
 * @email 756684177@qq.com
 * @date 2023/11/10 23:27
 */

declare(strict_types=1);

namespace app\console\controller;


use PhpOffice\PhpSpreadsheet\Exception;
use support\Request;

class Excel
{
    /**
     * @desc import
     * @param Request $request
     * @throws Exception
     * @throws \Exception
     * @author Tinywan(ShaoBo Wan)
     */
    public function import(Request $request)
    {
        $file = $request->file('file');
        if (empty($file) || !$file->isValid()) {
            throw new \Exception('无效的文件');
        }

        if (!in_array($file->getUploadExtension(), ['xlsx', 'pptx', 'docx', 'pdf'], true)) {
            throw new \Exception('上传文件格式不支持');
        }

        $reader = new \PhpOffice\PhpSpreadsheet\Reader\Xlsx();
        if (false === $reader->canRead($file->getRealPath())) {
            throw new \Exception('非法的Excel文件格式（如：强制转换文件后缀xls为xlsx）');
        }

        $excel = $reader->load($file->getRealPath());
        $sheelList = $excel->getSheet(0)->toArray();
        $importSheelList = array_slice($sheelList, 2);
        if (empty($importSheelList)) {
            throw new \Exception('数据为空，请填写后重新上传');
        }
        $importData = [];
        foreach ($importSheelList as $sheel) {
            array_push($importData, [
                'user_id' => (string)$sheel[0],
                'username' => (string)$sheel[1],
                'create_time' => time(),
            ]);
        }
        var_dump($importData);
    }
}

<?php
/**
 * @desc Excel 导出操作
 * @author Tinywan(ShaoBo Wan)
 * @email 756684177@qq.com
 * @date 2023/11/10 23:27
 */

declare(strict_types=1);

namespace app\console\controller;


use PhpOffice\PhpSpreadsheet\Cell\DataType;
use support\Request;
use support\Response;

class Excel
{
    /**
     * @desc 导出Excel
     * @param Request $request
     * @return Response
     * @throws \PhpOffice\PhpSpreadsheet\Writer\Exception
     * @author Tinywan(ShaoBo Wan)
     */
    public function import(Request $request)
    {
        $exportList = UserModel::where(['channel_id' => 10086])->order('id desc')->select();
        if ($exportList->isEmpty()) {
            throw new \Exception('暂无数据');
        }

        $spreadsheet = new \PhpOffice\PhpSpreadsheet\Spreadsheet();
        $sheet = $spreadsheet->getActiveSheet();
        // 设置默认行高
        $sheet->getDefaultRowDimension()->setRowHeight(18);
        $sheet->getStyle("A1:J1")
            ->getFont()
            ->setBold(true);
        $sheet->setCellValue('A1', '用户账号');
        $sheet->setCellValue('B1', '姓名');
        $sheet->setCellValue('C1', '观看时长');
        $sheet->setCellValue('D1', '开始时间');
        $sheet->setCellValue('E1', '结束时间');
        $sheet->setCellValue('F1', '观看IP');
        $sheet->setCellValue('G1', '观看地区');
        $sheet->setCellValue('H1', '观看终端（版本号）');
        $sheet->setCellValue('I1', '事件');
        $sheet->setCellValue('J1', '场次ID');
        $sheet->getColumnDimension('A')->setWidth(15);
        $sheet->getColumnDimension('B')->setWidth(10);
        $sheet->getColumnDimension('C')->setWidth(10);
        $sheet->getColumnDimension('D')->setWidth(20);
        $sheet->getColumnDimension('E')->setWidth(20);
        $sheet->getColumnDimension('F')->setWidth(15);
        $sheet->getColumnDimension('G')->setWidth(20);
        $sheet->getColumnDimension('H')->setWidth(25);
        $sheet->getColumnDimension('I')->setWidth(20);
        $sheet->getColumnDimension('J')->setWidth(40);

        foreach ($exportList as $key => $user) {
            $sheet->setCellValueExplicit("A" . ($key + 2), $user['user_id'], DataType::TYPE_STRING)
                ->setCellValueExplicit('B' . ($key + 2), $user['username'], DataType::TYPE_STRING)
                ->setCellValueExplicit('C' . ($key + 2), gmstrftime('%H:%M:%S', $user['duration']), DataType::TYPE_STRING)
                ->setCellValueExplicit('D' . ($key + 2), $user['create_time'], DataType::TYPE_STRING)
                ->setCellValueExplicit('E' . ($key + 2), $user['update_time'], DataType::TYPE_STRING)
                ->setCellValueExplicit('F' . ($key + 2), $user['client_ip'], DataType::TYPE_STRING)
                ->setCellValueExplicit('G' . ($key + 2), $user['region'], DataType::TYPE_STRING)
                ->setCellValueExplicit('H' . ($key + 2), $user['browser'], DataType::TYPE_STRING)
                ->setCellValueExplicit('I' . ($key + 2), $user['event'], DataType::TYPE_STRING)
                ->setCellValueExplicit('J' . ($key + 2), $user['session_id'], DataType::TYPE_STRING);
        }

        $writer = new \PhpOffice\PhpSpreadsheet\Writer\Xlsx($spreadsheet);
        ob_start();
        $writer->save("php://output");
        $xlsData = ob_get_contents();
        ob_end_clean();
        return json([
            'filename' => '[开源技术]导出直播观看记录.xlsx',
            'file' => "data:application/vnd.ms-excel;base64," . base64_encode($xlsData),
        ]);
    }
}