Laravel 上传excel，读取并写入数据库（实现自动建表、存记录值

最新推荐文章于 2024-07-12 11:00:15 发布

蜗牛慢慢向上爬

最新推荐文章于 2024-07-12 11:00:15 发布

阅读量9.6k

点赞数

本文链接：https://blog.csdn.net/a9925/article/details/51201405

版权

本文详细介绍了如何在Laravel框架下实现Excel文件的上传，读取其内容，并根据数据自动创建数据库表，进一步将数据存入数据库。这个过程涉及到文件上传、Excel解析以及数据库操作等技术。

摘要由CSDN通过智能技术生成

<?php

namespace App\Http\Controllers;

use Illuminate\Foundation\Bus\DispatchesJobs;
use Illuminate\Routing\Controller as BaseController;
use Illuminate\Foundation\Validation\ValidatesRequests;
use Illuminate\Foundation\Auth\Access\AuthorizesRequests;
use Illuminate\Support\Facades\Input;
use Maatwebsite\Excel\Facades\Excel;

use Illuminate\Database\Schema\Blueprint;
use Illuminate\Support\Facades\Schema;
use Illuminate\Support\Facades\DB;


class QueryController extends BaseController
{
    use AuthorizesRequests, DispatchesJobs, ValidatesRequests;
	public function index(){


		$file = Input::file('myfile');
		if($file){
//			$realPath = $file
//			$path = $file -> move(app_path().'/storage/uploads');
			$realPath = $file->getRealPath();
			$entension =  $file -> getClientOriginalExtension(); //上传文件的后缀.
			$tabl_name = date('YmdHis').mt_rand(100,999);