Newer
Older
smartKitchenFront / src / utils / exportExcel.js
liuyangyingjie on 26 Oct 2022 635 bytes first commit
import FileSaver from "file-saver";
import XLSX from "xlsx";

const htmlToExcel = {
  getExcel (dom, title = '默认标题',) {
    var excelTitle = title;
    var wb = XLSX.utils.table_to_book(document.querySelector(dom));
    /* 获取二进制字符串作为输出 */
    var wbout = XLSX.write(wb, { bookType: "xlsx", bookSST: true, type: "array" });
    try {
      FileSaver.saveAs(
        new Blob([wbout], { type: "application/octet-stream" }),
        excelTitle + ".xlsx"
      );
    } catch (e) {
      if (typeof console !== "undefined") console.log(e, wbout);
    }
    return wbout;
  }
};

export default htmlToExcel;