thinkphp导入excel教程

composer require phpoffice/phpspreadsheet

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

public function importExcel()
{
    $file = Request::instance()->file('excel_file'); // 获取上传的Excel文件
    if (!$file) {
        return json(['code' => 0, 'msg' => '文件未上传成功，请重试！']);
    }

    $spreadsheet = IOFactory::load($file->getRealPath()); // 加载Excel文件
    $sheet = $spreadsheet->getActiveSheet(); // 获取活动工作表
    $data = [];

    // 遍历工作表数据
    for ($row = 1; $row <= $sheet->getHighestRow(); $row++) {
        $cellValues = $sheet->rangeToArray('A' . $row . ':Z' . $row, null, true, true);
        $data[] = $cellValues[0];
    }

    // 将数据保存到数据库
    // ...

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