vue 导出excel

用xlsx插件
1、安装依赖包

npm install xlsx
npm install  file-saver

2、创建一个commom.js文件

import * as XLSX from "xlsx";
import FileSaver from 'file-saver'

export default {
  /**
   * 导出
   * @param mainTitle 主标题
   * @param subTitle 副标题
   * @param reqData
   * @returns {any}
   */
  exportTable(mainTitle,subTitle,reqData){
    /* generate workbook object from table */
    var timeTitle = this.getDate();
    // if(reqData.beginTime&&reqData.endTime){
    //   timeTitle = "-"+reqData.beginTime+"-"+reqData.endTime;
    // }  // 判断有没有时间
    if(subTitle){
      subTitle='-'+subTitle
    }else{
      subTitle = '';
    }
    let sheetjs=mainTitle+subTitle+timeTitle;

    let xlsxParam = { raw: true }
    var wb = XLSX.utils.table_to_book(document.querySelector('#outTable'),xlsxParam)
    /* get binary string as output */
    var wbout = XLSX.write(wb, { bookType: 'xlsx', bookSST: true, type: 'array' })
    try {
      FileSaver.saveAs(new Blob([wbout], { type: 'application/octet-stream' }), sheetjs+".xlsx")
    } catch (e) { if (typeof console !== 'undefined') console.log(e, wbout) }
    return wbout
  },
  /**
   * 创建当前时间
   * */
  getDate(){
    var date = new Date(),
        year = date.getFullYear(),
        month = date.getMonth() + 1,
        day = date.getDate(),
        hour = date.getHours() < 10 ? "0" + date.getHours() : date.getHours(),
        minute = date.getMinutes() < 10 ? "0" + date.getMinutes() : date.getMinutes(),
        second = date.getSeconds() < 10 ? "0" + date.getSeconds() : date.getSeconds();
    month >= 1 && month <= 9 ? (month = "0" + month) : "";
    day >= 0 && day <= 9 ? (day = "0" + day) : "";
    // var timer = year + '-' + month + '-' + day + ' ' + hour + ':' + minute + ':' + second;
    var timer = year + '-' + month + '-' + day;
    return timer;
  },
}

3、在表格上加上id

<el-table  id='outTable'></el-table>

4、在页面引入方法

import comon from "@/api/commom";

5、在按钮上添加click方法

exportExcel () {
   comon.exportTable(this.title,'','')
},

就可以实现导出了