Vue项目json数据导出Excel

一、安装依赖

npm i -S file-saver
npm i -S xlsx

二、在src目录下新建excel文件夹，新建json2excel.js，并引入依赖

import { saveAs } from 'file-saver'
import XLSX from 'xlsx/dist/xlsx.full.min'

三、json2excel.js

将json数据处理为xlsx需要的格式

function datenum(v, date1904) {
    if (date1904) v += 1462
    let epoch = Date.parse(v)
    return (epoch - new Date(Date.UTC(1899, 11, 30))) / (24 * 60 * 60 * 1000)
}

function data2ws(data) {
    const ws = {}
    const range = {s: {c: 10000000, r: 10000000}, e: {c: 0, r: 0}}
    for (let R = 0; R != data.length; ++R) {
        for (let C = 0; C != data[R].length; ++C) {
            if (range.s.r > R) range.s.r = R
            if (range.s.c > C) range.s.c = C
            if (range.e.r < R) range.e.r = R
            if (range.e.c < C) range.e.c = C
            const cell = { v: data[R][C] }
            if (ce