react 导入excel

import XLSX from ‘xlsx’;
importfile(e){
const { onChange } = this.props;
if(!e.target.files) return ;
const file=e.target.files[0];
var daochu = this.daochu;
const values = this.props.form.getFieldsValue()
const reader=new FileReader();
reader.readAsBinaryString(file);
reader.οnlοad=function(e){
const data=this.result;
const wb=XLSX.read(data, {
type: ‘binary’
})
const params = XLSX.utils.sheet_to_json(wb.Sheets[wb.SheetNames[0]]);

        for(var i = 0; i<params.length; i++){
            params[i].Name = params[i].客户名称 ;
            delete params[i].客户名称 ;
            params[i].GenderName = params[i].性别 ;
            delete params[i].性别 ;
            params[i].Tel = params[i].联系电话 ;
            delete params[i].联系电话 ;
            params[i].WeChat = params[i].微信 ;
            delete params[i].微信 ;
            // params[i].qq = params[i].qq ;
            // delete params[i].qq ;
            params[i].StateValue = params[i].客户状态 ;
            delete params[i].客户状态 ;
            params[i].SourceValue = params[i].客户来源 ;
            delete params[i].客户来源 ;
            params[i].Address = params[i].通信地址 ;
            delete params[i].通信地址 ;
            params[i].ProvinceName = params[i].省 ;
            delete params[i].省 ;
            params[i].CityName = params[i].市 ;
            delete params[i].市 ;
            params[i].CountyName = params[i].区县 ;
            delete params[i].区县 ;
            params[i].EducationName = params[i].学历 ;
            delete params[i].学历 ;
            params[i].PoliticalOutlookName = params[i].政治面貌 ;
            delete params[i].政治面貌 ;
            params[i].CustomerLableValue = params[i].客户标签 ;
            delete params[i].客户标签 ;
            params[i].Remark = params[i].备注 ;
            delete params[i].备注 ;
        }

        request(`/api/C_Customer/ImportEnterpriseCustomer`, { method : 'POST' , body: params  })
            .then((req) => {
                if(req.Success){
                    notification.success({
                        message: '导入成功',
                        description: req.Message
                    });
                    onChange(values)
                }else{
                    if(req.ReturnData){
                        var data = [];
                        data = req.ReturnData;
                        Modal.error({
                            title: '导入失败',
                            content: req.Message,
                            okText:'下载文件',
                            maskClosable:true,
                            onOk: () => {
                                daochu(data)
                            }
                        });
                    }else{
                        Modal.error({
                            title: '导入失败',
                            content: '必填数据不能为空',
                            okText:'知道了',
                            maskClosable:true,
                        });
                    }
                }
            })  
    }
    this.input.value=null
}
daochu = (dataArr) => {
    const params = this.props.form.getFieldsValue();
    const param={
        ...params,
        StateKey:this.state.activeKey,
        SourceKey:params['SourceKey']==='null'?undefined:params['SourceKey']
    }
    const datas =  dataArr;
    const wopts = { bookType: 'xlsx', bookSST: false, type: 'binary' };//这里的数据是用来定义导出的格式类型
    const wb = { SheetNames: ['Sheet1'], Sheets: {}, Props: {} };
    const data=datas.map(item=>{
        return {
            '客户名称':item.Name,
            '联系电话':item.Tel,
            '客户标签':item.CustomerLableValue,
            '客户状态':item.StateValue,
            '距上次跟进(天)':item.OutTrackDay,
            '客户来源':item.SourceValue,
            '业务员':item.SalesmanName,
            '省份':item.ProvinceName,
            '城市':item.CityName,
            '区县':item.CountyName,
            '学历':item.EducationName,
            '性别':item.Gender == 0 ? '男':'女',
            '政治面貌':item.PoliticalOutlookName,
            'QQ':item.QQ,
            '类型':item.Type==1?'个人客户':'企业客户',
            '联系次数':item.ContactNum,
            '微信':item.WeChat,
            '错误信息': item.ErrorInfo
        }
    })
    wb.Sheets['Sheet1'] = XLSX.utils.json_to_sheet(data);//通过json_to_sheet转成单页(Sheet)数据
    this.saveAs(new Blob([this.s2ab(XLSX.write(wb, wopts))], { type: "application/octet-stream" }), "个人客户导出" + '.' + (wopts.bookType=="biff2"?"xls":wopts.bookType));
}

// 导出excel
saveAs(obj, fileName){
    var tmpa = document.createElement("a");
    tmpa.download = fileName || "下载";
    tmpa.href = URL.createObjectURL(obj); //绑定a标签
    tmpa.click(); //模拟点击实现下载
    setTimeout(function () { //延时释放
        URL.revokeObjectURL(obj); //用URL.revokeObjectURL()来释放这个object URL
    }, 100);
}

s2ab(s) {
    if (typeof ArrayBuffer !== 'undefined') {
        var buf = new ArrayBuffer(s.length);
        var view = new Uint8Array(buf);
        for (var i = 0; i != s.length; ++i) view[i] = s.charCodeAt(i) & 0xFF;
        return buf;
    } else {
        var buf = new Array(s.length);
        for (var i = 0; i != s.length; ++i) buf[i] = s.charCodeAt(i) & 0xFF;
        return buf;
    }
}