composer安装 composer require "phpoffice/phpexcel": "*"
建一个上传模型Upload.php
<?php
namespace app\models;
use Yii;
use yii\base\Model;
class Upload extends Model{
public $file;
public function rules(){
return [
[['file'], 'file', 'extensions' => 'xls'],
];
}
public function attributeLabels(){
return [
'file'=>'文件上传'
];
}
}
建一个视图文件import.php
<?php
use yii\widgets\ActiveForm;
?>
<input type="button" class="btn btn-xs btn-success" data-toggle="modal" data-target="#myModal" id="import" value="导入excell" />
<div class="modal fade" id="myModal" tabindex="-1" role="dialog" aria-labelledby="myModalLabel" aria-hidden="true">
<?php $form = ActiveForm::begin(); ?>
<div class="modal-dialog" >
<div class="modal-content">
<div class="modal-header">
<button type="button" class="close" data-dismiss="modal"
aria-hidden="true">×
</button>
<h4 class="modal-title" id="myModalLabel">
导入Excell
</h4>
</div>
<div class="modal-body">
<div class="row">
<div class="col-xs-12">
<div class="form-group">
<div class="col-sm-9">
<?= $form->field($model, 'file')->fileInput() ?>
<span class="Validform_checktip"><