thinkphp 如何把excel导入

composer require phpoffice/phpspreadsheet

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

class ExcelController extends Controller
{
    public function importExcel()
    {
        // 检查是否有文件上传
        if (Request::has('file', 'file')) {
            $file = Request::file('file');
            try {
                // 加载 Excel 文件
                $spreadsheet = IOFactory::load($file->getRealPath());
                $worksheet = $spreadsheet->getActiveSheet();

                // 遍历工作表中的每一行
                foreach ($worksheet->getRowIterator() as $row) {
                    $cellIterator = $row->getCellIterator();
                    $cellIterator->setIterateOnlyExistingCells(false); // 遍历所有单元格，即使它们没有值

                    $rowData = [];
                    foreach ($cellIterator as $cell) {
                        $rowData[] = $cell->getValue();
                    }

                    // 将数据插入数据库
                    // 这里假设你有一个模型 UserModel 来处理数据库操作
                    UserModel::create($rowData);
                }

                return json(['code' => 0, 'msg' => '导入成功']);
            } catch (\Exception $e) {
                return json(['code' => 1, 'msg' => '导入失败: ' . $e->getMessage()]);
            }
        } else {
            return json(['code' => 1, 'msg' => '没有文件上传']);
        }
    }
}

Route::post('import_excel', 'ExcelController@importExcel');

<form action="/import_excel" method="post" enctype="multipart/form-data">
    <input type="file" name="file" />
    <button type="submit">上传</button>
</form>

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