vue基于Export2Excel.js 做导出Excel表格

New__Random

已于 2023-02-24 11:51:29 修改

阅读量710

点赞数

文章标签：前端 vue.js javascript

于 2023-02-24 11:17:06 首次发布

本文链接：https://blog.youkuaiyun.com/New__Random/article/details/126094844

版权

1.安装导出所需要的三个依赖

npm install -S file-saver
npm install -S xlsx
npm install -D script-loader

2.导入js文件

新建文件夹 vendor

将Export2Excel.js 导入

Export2Excel.js

/* eslint-disable */
require('script-loader!file-saver');
// import XLSX from 'xlsx'
import * as 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 = colspa