Excel 表导入数据

\DB::table($tableName)->truncate(); //先清空表
        if($tableName == "game_challenges") {
            \DB::table('game_challenge_commands')->truncate(); //先清空表
        }
        $filePath = '/home/share/update_db/'.$tableName.'.xlsx';
        Excel::selectSheets('Sheet1')->load($filePath, function($reader) use($tableName,$options) {
            $time = time();
            $reader = $reader->getSheet(0);//获取excel的第1张表
            $results = $reader->toArray();//获取表中的数据

            array_shift($results);
            foreach ($results as $k => $v) {
                if($v[0] === null) {
                    unset($results[$k]);
                }
            }
            $time = time();
            $arr = [];

            //自行开发...

laravel5,5 安装扩展包"maatwebsite/excel": "~2.1.0"

本作品采用《CC 协议》，转载必须注明作者和本文链接