vue xlsx导出网页表格(将table dom拼装成json)

      var trs = document.getElementById("out-table").getElementsByTagName("tr"); //获得tr数组
      var titles = document
        .getElementsByClassName("has-gutter")[0]
        .getElementsByTagName("th"); //获得表头td数组
      //console.log(titles[0].firstChild.innerHTML);
      var json = "";
      for (var i = 1; i < trs.length; i++) {
        var tds = trs[i].getElementsByTagName("td");
        json += "{";
        //拼装json
        for (var j = 0; j < tds.length; j++)
          json +=
            '"' +
            titles[j].firstChild.innerHTML +
            '"' +
            ":" +
            '"' +
            tds[j].firstChild.innerHTML +
            '"' +
            ",";
        json = json.substring(0, json.length - 1) + "},";
      }
      json = "[" + json.substring(0, json.length - 1) + "]";
 
      // 将数据转成workSheet
      let jsonWorkSheet = XLSX.utils.json_to_sheet(JSON.parse(json));


      // 构造workBook
      let workBook = {
        SheetNames: ["jsonWorkSheet"],
        Sheets: {
          jsonWorkSheet: jsonWorkSheet
        }
      };
      // 将workBook写入文件
      XLSX.writeFile(workBook, "./aa.xlsx");

1011382654

海报 链接