yii2.0--上传excel文件后导入到数据库

Model模型

<?php
/**
 * 描述...
 * @author zcy
 * @date 2019/8/13
 */

namespace app\models;


use yii\base\Model;
use yii\db\ActiveRecord;
use yii\web\UploadedFile;

class uploadForm extends ActiveRecord
{
    public $file;

    public function rules()
    {
        return [
            [['file'],'file', 'skipOnEmpty' => false,'extensions' => 'xls,xlsx'],
        ];
    }

    public function attributeLabels()
    {
        return [
            'file'=> '上传文件'
        ];
    }

    public function upload()
    {
        $file = UploadedFile::getInstance($this, 'file');

        if ($this->rules()) {
            $tmp_file = $file->baseName . '.' . $file->extension;
            $path = 'upload/' . 'Files/';
            if (is_dir($path)) {
                $file->saveAs($path . $tmp_file);