前端处理二进制流文件导出为excel表

将后端返回的二进制流文件 导出为excel表
用的时候直接调用showConfirm函数即可
最后效果

exportfunctiongetExport(param){get('/api/xdata/v1/basic/auth/excel',{...param }).then((res)=>{// let name = getFileName(url);let name ='export.xlsx';
        console.log('res', res);// let u = window.URL.createObjectURL(new Blob([res]));const type ='application/vnd.ms-excel;charset=utf-8';//excel文件let u = window.URL.createObjectURL(newBlob([res],{type: type }));let a = document.createElement('a');
        a.download = name;
        a.href = u;
        console.log(a);
        a.style.display ='none';
        document.body.appendChild(a);
        a.click();
        a.remove();// setTimeout(myDlWarn, 0);});}exportfunctionshowConfirm(text, exportParams){confirm({title:`您确认要导出${text}吗`,icon:<ExclamationCircleOutlined />,content:'',okText:'确认',okType:'primary',cancelText:'取消',onOk(){getExport(exportParams);},onCancel(){
            console.log('Cancel');},});}

get接口是自己封装的，封装如下

/**
 * 从 cookie 中获取数据
 * @param {string} cname cname
 */exportconstgetCookie=(cname)=>{var name = cname +'=';var ca = document.cookie.split(';');for(var i =0; i < ca.length; i++){var c = ca[i].trim();if(c.indexOf(name)===0){return c.substring(name.length, c.length);}}return'';};constajax=(method, url, data, options ={})=>{const isPost = method ==='post';const isPut = method ==='put';const isPatch = method ==='patch';const isGet = method ==='get';const sentOptions ={
        url,
        method,withCredentials:true,// 允许跨域credentials:'include',headers:{'X-Request-By':'ERApplication','X-Requested-With':'XMLHttpRequest','X-Region':'bj','X-From':'web',},...options,};if(isPost || isPatch){
        sentOptions.headers['Content-Type']='application/x-www-form-urlencoded';
        sentOptions.data =JSON.stringify(data);}elseif(isPut){
        sentOptions.data =JSON.stringify(data);}elseif(isGet){
        sentOptions.headers['Content-Type']='utf-8';
        sentOptions.params = data;}returnnewPromise((resolve, reject)=>{axios(sentOptions).then((response)=>{resolve(response.data);.catch((error)=>{
                console.log('catch');reject(error);});});};exportconstget=(url, data ={})=>{returnajax('get',BASE_URL+ url, data,{responseType:'blob'});};