写一个excel导入加过滤

//首先引入bootstrap 来作为样式

<button class="btn btn-info" type="button" id="import" data-toggle="modal" data-target="#myModal">导入</button>

 <div class="modal fade" id="myModal" tabindex="-1" role="dialog" aria-labelledby="myModalLabel">
        <div class="modal-dialog" role="document">
            <div class="modal-content">
                <div class="modal-header">
                    <button type="button" class="close" data-dismiss="modal" aria-label="Close"><span aria-hidden="true">&times;</span></button>
                    <h4 class="modal-title" id="myModalLabel">导入</h4>
                </div>
                <div class="modal-body">
                    <div>导入格式如下  <a href="/public/yuangongmoban.xls" download="员工导入模板.xls">下载模板</a> </div>
                    <table class="table table-bordered" id="contents" >
                        <tr>
                            <th>编号</th>
                            <th>姓名</th>
                            <th>手机号</th>
                            <th>员工分组</th>
                            <th>员工级别</th>
                            <th>是否删除</th>
                        </tr>
                        <tr>
                            <td>1</td>
                            <td>小刘</td>
                            <td>18888888888</td>
                            <td>冲锋组</td>
                            <td>组长</td>
                            <td></td>
                        </tr>
                        
                    </table>
                    <div id="rename" style="color: red;">   </div>
                    <div id="unname" style="color: red;">   </div>
                   
                    <form action="#" method="post" id="file-form" enctype="multipart/form-data">
                        <div class="form-group">
                            <label class=" control-label" style="width:85px;">上传文件<sup>*</sup></label>
                            <div class="">
                                <input type="file" id="avatarUpload" name="excel" style="display:block;" />
                            </div>
                        </div>
                    </form>
                </div>
                <div class="modal-footer">
                    <a  class="btn btn-default" data-dismiss="modal" id="file-import">确定</a>
                    <!--<button type="button" class="btn btn-danger" id="editUser">确定</button>-->
                </div>
            </div>
        </div>
    </div>

<script>
var  update_arr = [];
//导入
    $(‘#file-import‘).on(‘click‘,function(){
        
        var fileFlag = false;
        fileFlag = $("input[name=‘excel‘]").val();
        if(!fileFlag) {
            alert( ‘请选择文件！‘);
            return false;
        }
        // 创建
        var form_data = new FormData();
        // 获取文件
        var file_data = $("input[name=‘excel‘]").prop("files")[0];
        // 把所以表单信息
        form_data.append("excel", file_data);
        
        $.ajax({
            url:"{:U(‘Employee/import‘)}",
            type:‘post‘,
            dataType:‘json‘,
            processData: false, 
            contentType: false,  
            data: form_data,
            success:function(data){
              console.log(data)
                if(data.resCode == 1){
                  $("#contents tr:gt(0)").remove();
                  $("#contents tbody").append(data.resData.text);
                  if(data.resData.renum){
                     $("#rename").html(‘系统删除重复人员：‘+data.resData.rename+‘共计人数：‘+data.resData.renum);
                  }
                 
                  $("#unname").html(‘系统删除不合格人员：‘+data.resData.unname+‘共计人数：‘+data.resData.unnum+‘<button type="button" class="btn btn-danger  addUser" style="margin-left:230px;" id="addUser">确认添加</button>‘)
                  update_arr = data.resData.data
                }else{
                  alert(data.msg)
                }
            },
            error:function(data){
                console.log(data,111)
            }
        })
        return  false;
    });

//删除
function getDel(k,key){ 
  delete update_arr[key];
  $(k).parent().remove(); 
} 

// 最后确定上传
$("#unname").delegate(‘.addUser‘, ‘click‘, function () { 
　　　　 $.ajax({
             url:"{:U(‘Employee/add_user_all‘)}",
             type:‘post‘,
             dataType:‘json‘,
             data:{"data":update_arr},
             success:function(data){
                if(data.resCode == 1){
                  alert(data.resMsg)
                  window.location.reload()
                }else{
                   alert(data.resMsg)
                }
              },
             error:function(data){
                 console.log(data,111)
             }
         })

  });

function repeat(a) {
$(‘#modal_volume‘+a).fadeIn();
}

function repeat2(a) {
$(‘#modal_volume‘+a).fadeOut();
}

$("#avatarUpload").change(function()
{
      var extArray = [‘.xlsx‘,‘.xls‘];
      var file = event.currentTarget.files[0];
      var url = window.URL.createObjectURL(file);
      var name = file[‘name‘];
      var ext = name.substr(name.lastIndexOf(‘.‘));
      if($.inArray(ext,extArray)<0){
          alert(‘上传格式错误！目前只支持xlsx ，xls‘);
          $("#avatarUpload").val("");
          return false;
      }
      
});


</script>