vue3+xlsx+xlsx-style导出excel文件

1.安装插件

"file-saver": "^2.0.5",

"xlsx": "^0.17.0",

"xlsx-style": "^0.8.13"

npm i xlsx@0.17.0 -S

npm i xlsx-style@0.8.13 -S

npm i file-saver -S

2.配置vue.config.js

configureWebpack: {
    resolve: {
      alias: {
        '@': resolve('src')
      },
      fallback: { fs: false }
    },
    externals: {
      './cptable': 'var cptable'
    },
}

3.导出excel表格

import { ElMessageBox } from 'element-plus' 
import XLSX from "xlsx"; 
import XLSXS from 'xlsx-style' 
import FileSaver from 'file-saver' 
// 导出的数据 
const tableData = [ 
    { date: '2016-05-03', name: 'Tom', address: '123', }, 
    { date: '2016-05-02', name: 'Tom', address: '456', }, 
    { date: '2016-05-04&#