vue使用xlsx完成表格导出

安装依赖

指定版本是为了防止在使用过程中出现 utils 报错

npm install xlsx@0.17.0
npm install file-saver@2.0.5

Export2Excel.js

/* eslint-disable */
import {
    saveAs } from "file-saver";
import XLSX from "xlsx";

function generateArray(table) {
   
  var out = [];
  var rows = table.querySelectorAll("tr");
  var ranges = [];
  for (var R = 0; R < rows.length; ++R) {
   
    var outRow = [];
    var row = rows[R];
    var columns = row.querySelectorAll("td");
    for (var C = 0; C < columns.length; ++C) {
   
      var cell = columns[C];
      var colspan = cell.getAttribute("colspan");
      var rowspan = cell.getAttribute("rowspan");
      var cellValue = cell.innerText;
      if (cellValue !== "" && cellValue == +cellValue) cellValue = +cellValue;

      //Skip ranges
      ranges.forEach(function(range) {
   
        if (
          R >= range.s.r &&
          R <= range.e.r &&
          outRow.length >= range.s.c &&
          outRow.length <= range.e.c
        ) {
   
          for (var i = 0; i <= range.e.c - range.s.c; ++i) outRow.push(null);
        }
      });

      //Handle Row Span
      if (rowspan || colspan) {
   
        rowspan = rowspan || 1;
        colspan = colspan || 1;
        ranges.push({
   
          s: {
   
            r: R,
            c: outRow.length,
          },
          e: {
   
            r: R + rowspan - 1,
            c: outRow.length + colspan - 1,
          },
        });
      }

      //Handle Value
      ou