下载excel文件 js

function downloadExcel() {
    // 假设我们有一个包含数据的二维数组
    const data = [
        ['Name', 'Age', 'Email'],
        ['John Doe', 30, 'john@example.com'],
        ['Jane Smith', 25, 'jane@example.com']
    ];

    // 使用SheetJS库将数据转换为XLSX格式
    const worksheet = XLSX.utils.aoa_to_sheet(data);
    const workbook = XLSX.utils.book_new();
    XLSX.utils.book_append_sheet(workbook, worksheet, 'Sheet1');

    // 将工作簿转换为二进制字符串
    const wbout = XLSX.write(workbook, {bookType:'xlsx', type:'binary'});

    function s2ab(s) {
        const buf = new ArrayBuffer(s.length);
        const view = new Uint8Array(buf);
        for (let i=0; i<s.length; i++) view[i] = s.charCodeAt(i) & 0xFF;
        return buf;
    }

    // 创建Blob对象
    const blob = new Blob([s2ab(wbout)], {type:"application/octet-stream"});

    // 创建并触发下载链接
    const link = document.createElement("a");
    const url = URL.createObjectURL(blob);
    link.setAttribute("href", url);
    link.setAttribute("download", "data.xlsx");
    link.style.visibility = 'hidden';
    document.body.appendChild(link);
    link.click();
    document.body.removeChild(link);
}

// 调用函数下载Excel文件
downloadExcel();