onemap-implementationSupervision-system-frontend/website/src/utils/map/exportExcel.js

/*
 * @Descripttion: 导出表格
 * @version:
 * @Author: siwei
 * @Date: 2022-09-14 12:02:28
 * @LastEditors: siwei
 * @LastEditTime: 2022-09-14 14:49:16
 */
import FileSaver from "file-saver";
import * as XLSX from "xlsx";

export let outputXLSX = (filename, selector, _this) => {
    selector = selector || "#mytable"; //mytable为默认的表格id名
    filename = filename; // 文件名
    var wb = XLSX.utils.table_to_book(document.querySelector(selector), {
        raw: true,
    });

    var wbout = XLSX.write(wb, {
        bookType: "xlsx",
        bookSST: false,
        type: "array",
    });
    try {
        FileSaver.saveAs(
            new Blob([wbout], { type: "application/octet-stream" }),
            filename + ".xlsx"
        );
        if (_this) _this.$message.success("导出成功"); //导出成功的提示
    } catch (e) {
        if (typeof console !== "undefined") console.log(e, wbout);
    }
    return wbout;
};