sheet('score', function ($sheet) use ($cellData) {                     $sheet->rows($cellData);                 });             })->export('xls');*/        //方法二：        $users = AdminUser::all()->toArray();        $header[] = array('ID号', '姓名', '邮箱', '创建时间', '状态');        $arr = array();        foreach ($users as $one) {            $data = array($one['id'], $one['name'], $one['email'], $one['created_at'], $one['status']);            array_push($arr, $data);        }        $arrData = array_merge($header, $arr);        Excel::create(iconv('UTF-8', 'UTF-8', '管理员表'), function ($excel) use ($arrData) {            $excel->sheet('score', function ($sheet) use ($arrData) {                $sheet->rows($arrData);            });        })->store('xlsx')->export('xlsx');    }    //导入    public function import(Request $request)    {        /*$filePath = 'storage/exports/' . iconv('UTF-8', 'GBK', '学生成绩') . '.xls';        Excel::load($filePath, function ($reader) {            $data = $reader->all();            dd($data);        });*/        //        $file=Input::file('file');        dd(base_path());        $file = $request->file('file');        $tabl_name = date('YmdHis', time()) . rand(100, 999);        $entension = $file->getClientOriginalExtension(); //上传文件的后缀.        $new_name = $tabl_name . '.' . $entension;        if ($file->isValid()) {            $path = $request->file('file')->storeAs('import', $new_name);            // 更新文件本地地址  storage/import/20180720105908.xlsx            $path = '/public/storage/' . $path;            // dd($path); ///public/storage/import/20180720124843.xlsx"            Excel::load($path, function ($reader) use ($tabl_name) {                //$data = $reader->all();                //获取Excel的第几张表                $reader = $reader->getSheet(0);                //获取表中数据                $data = $reader->toArray();//                dd($data);                $result = $this->create_table($tabl_name, $data);//                dd($result);            });        }        return redirect('/admin/files');    }    //创建表    public function create_table($table_name, $field_arr)    {        $tmp = $table_name;        $val = $field_arr;        //创建表结构  因为已经有db_import表不再需要执行创建表结构程序。        //注意Excel标题最好是英文        /*  $tables = DB::select("show tables");          $tables = array_column($tables, 'Tables_in_blog');*/        $tables = array_map('reset', \DB::select('SHOW TABLES'));        if (!in_array('db_import', $tables)) {            Schema::dropIfExists('db_import');            Schema::create("db_import", function (Blueprint $table) use ($tmp, $val) {                $fields = $val[0];          //列字段                $table->increments('id');  //主键                foreach ($fields as $key => $value) {                    $table->string($fields[$key]);                }            });        }        //填充数据        $value_str = array();        if ($id = DB::table('db_import')->max('id')) {            $id = $id + 1;        } else {            $id = 1;        }        //$id = DB::table('db_import')->max('id') ? DB::table('db_import')->max('id') + 1 : 1;        foreach ($val as $key => $value) {            if ($key != 0) {//                $content = implode(',', $value);//                $content2 = explode(',', $content);                foreach ($value as $key2 => $va2) {                    if (!empty($va2)) {                        $value_str[] = "'$va2'";                    }                }                $news = implode(',', $value_str);                if (!empty($news)) {                    $news = "$id," . $news;                    DB::insert("insert into db_import VALUES ($news)");                }                $value_str = array();                $id = $id + 1;            }        }        return $id;    }}