含样式导出Excel

最新推荐文章于 2024-07-18 13:50:38 发布

就这样敲

最新推荐文章于 2024-07-18 13:50:38 发布

阅读量41

点赞数

文章标签： excel 前端 javascript

本文链接：https://blog.csdn.net/luyangguo/article/details/134056288

版权

含样式导出Excel

  Download(filename) {
    var oHtml = document.getElementsByClassName("tableA")[0].outerHTML;
    console.log(document.getElementsByClassName("tableA"));

    var excelHtml = `<html>  <head>  <meta charset='utf-8' /> <style>
              .tableA { border-collapse: collapse; color: black;}
              .tableA .title th {   font-weight: bold; font-style:italic;font-family:Verdana; text-align: center;padding: 5px; height: 50px; width: 100%;font-size: 20pt;}
              .tableA tr th { border:1px solid #e8eaec; height: 40px;   width:auto;  background-color:#A7C942; }
              .tableA tr td { padding: 0 40px;  border:1px solid #e8eaec; height: 40px;  width:auto;  text-align: center; }
              .textpadder{mso-number-format:'\@'}
              </style> </head>  <body> ${oHtml}</body> </html>`;
    // var debug = { hello: "world" };
    console.log(excelHtml);
    //在导出的表格中显示为文本格式
    //  mso-number-format:'\@'
    // var blob = new Blob([JSON.stringify(debug, null, 2)], {
    //   type: "application/json"
    // });
    var excelBlob = new Blob([excelHtml], {
      type: "application/vnd.ms-excel"
    });
    // 创建一个a标签
    //兼容 IE
    if (window.navigator && window.navigator.msSaveOrOpenBlob) {
      window.navigator.msSaveOrOpenBlob(excelBlob, filename);
    } else {
      var oA = document.createElement("a");
      // 利用URL.createObjectURL()方法为a元素生成blob URL
      oA.href = URL.createObjectURL(excelBlob);
      // 给文件命名
      oA.download = filename;
      // 模拟点击
      oA.click();
    }
  },