TP5实现excel导入

1. 安装phpoffice/phpspreadsheet

	composer require phpoffice/phpspreadsheet

2. PHP代码示例

    public function import($file) {
        $ext = $file->getOriginalExtension();
        if(!in_array( $ext, ['xls','xlsx'])){
            return '请上传xls或者xlsx格式';
        }
        // 我是放在了public下的storage下的file文件夹
        $filePath ='/file';
        $fileName = time().'.'.$ext;
        $savename = \think\facade\Filesystem::disk('public')->putFileAs( $filePath, $file,$fileName);
        $path = public_path().'/storage/'.$savename;
        if($ext=="xlsx"){
            $reader = IOFactory::createReader('Xlsx');
        }else{
            $reader = IOFactory::createReader('Xls');
        }
        $excel = $reader->load($path,$encode = 'utf-8');//这个地方新版本第二个参数好像是int类型，直接删掉不传就好了

        //读取第一张表
        $sheet = $excel->getSheet(0)->toArray();

        array_shift($sheet);  //删除第一个数组(标题);

		// $sheet即为excel中除表头外的数据数组
		// TODO::循环插入数据库
    }