导出 el-table 为 xlsx文件

"file-saver": "^2.0.5",
"xlsx": "^0.18.5",

import FileSaver from "file-saver";
import { utils, write } from "xlsx";

function testDownload (){

    var xlsxParam = {raw: true};

    var excelDom = utils.table_to_book(document.querySelector(".test1111"),xlsxParam);
    console.log(excelDom);

    var excelType= write(excelDom,{
        bookType:'xlsx',
        bookSST:true,
        type:"array"
    })

    FileSaver.saveAs(
        new Blob([excelType],{type:"application/octet-stream"}),"test.xlsx"
    )
}
posted @ 2023-05-09 14:57  进阶的哈姆雷特  阅读(17)  评论(0编辑  收藏  举报