根据表格数据批量改数据库

public function upload(){
        $file = \request()->file('file');
        $spreadsheet =  IOFactory::load($file->getPathname());
        $sheet = $spreadsheet->getSheet(0);//获取第一个表
        $highestRow = $sheet->getHighestRow();//获取行数
        $data_str = '';
        for ($j = 1; $j <= $highestRow; $j++) {
            $temp =  $spreadsheet->getActiveSheet()->getCell("A" . $j)->getFormattedValue();//获取数据
            $temp = trim($temp);
          根据实际情况写mysql修改语句
            Log::record("修改".$temp);
            Log::record(Db::name('name')->getLastSql());
        }
}

需要引用：

use PhpOffice\PhpSpreadsheet\IOFactory;