封装 vue 导出 xlsx

export function xhrToExportFile(url, method = 'GET', fileName = "文件名称", params = {}, fileType = 'xlsx') {
    const token = getCookie(`PHPSESSID`) || '';
    let xhr = new XMLHttpRequest();
    const hasParams = Object.keys(params).length > 0;
    if (method === 'GET' && hasParams) {
        const keys = Object.keys(params);
        keys.forEach((item, index) => {
            url += `${index === 0 ? '?' : '&'}${item}=${params[item]}`
        })
    }
    xhr.open(method, `${url}`, true);
    xhr.setRequestHeader("phpsessid", token);
    xhr.setRequestHeader('content-type', 'application/json; charset=UTF-8');
    xhr.responseType = "blob";

    xhr.onload = function(e) {
        if (this.status == 200) {
            let blob = this.response;
            let reader = new FileReader();

            reader.readAsDataURL(blob)
            reader.onload = function(e) {
                let a = document.createElement("a");
                a.download = `${fileName}.${fileType}`;
                a.href = e.target.result;
                // 修复firefox中无法触发click
                document.getElementsByTagName('body')[0].append(a);
                a.click();
                a.remove();
            };
        } else {
            xhr.send();
        }
    };
    if (hasParams || method === 'POST') {
        xhr.send(JSON.stringify(params));
    } else {
        xhr.send();
    }
}


import { json2Form,xhrToExportFile } from '@/tools/util';

try {
 xhrToExportFile(exportSpecial, 'POST', '专场信息表', this.ad_form);
} catch (e) {
   this.$message.error(`导出错误：${e}`)
 }