vue--- xlsx 前端下载excel【vue2】

命令安装：

npm install file-saver --save

npm install xlsx --save

main.js:

var XLSX = require("xlsx");

引用的页面：

import * as XLSX from 'xlsx/xlsx.mjs';

/* load 'fs' for readFile and writeFile support */

import * as fs from 'fs';

XLSX.set_fs(fs);

/* load 'stream' for stream support */

import { Readable } from 'stream';

XLSX.stream.set_readable(Readable);

/* load the codepage support library for extended support with older formats  */

import * as cpexcel from 'xlsx/dist/cpexcel.full.mjs';

XLSX.set_cptable(cpexcel);

// Acquire Data (reference to the HTML table)

var table_elt = document.getElementById("my-table-id");

// Extract Data (create a workbook object from the table)

var workbook = XLSX.utils.table_to_book(table_elt);

// Process Data (add a new row)

var ws = workbook.Sheets["Sheet1"];

XLSX.utils.sheet_add_aoa(ws, [["Created "+new Date().toISOString()]], {origin:-1});

// Package and Release Data (`writeFile` tries to write and save an XLSB file)

XLSX.writeFile(workbook, "Report.xlsb");