【vue+xlsx】前端可复制使用的导出excel方法

安装xlsx

npm install xlsx file-saver --save 

点击事件

<el-button type="primary" @click="getExcel">导出</el-button>

js部分

注意组成的数据是二维数组

import * as XLSX from 'xlsx'

    getExcel() {
     // 表格表头
      let tableData = [
            ['序号', '土壤', '气象', "录入时间",  "状态"]
       ]
      this.selectdata.forEach((item, index) => {
            let rowData = []
            //导出内容的字段
            rowData = [
              index + 1,
              item.tr,
              item.qx,
              item.time,
              item.status,
              ,
            ]
            tableData.push(rowData)
          })      
      let workSheet = XLSX.utils.aoa_to_sheet(tableData)
      let bookNew = XLSX.utils.book_new()
      XLSX.utils.book_append_sheet(bookNew, workSheet, '气象数据') // 工作簿名称
      let name = '气象数据' + this.timeFormat() + '.xlsx'
      XLSX.writeFile(bookNew, name) // 保存的文件名
    },

    timeFormat() {
        let time = new Date();
        let year = time.getFullYear();
        let month = time.getMonth() + 1;
        let date = time.getDate();
        let hours = time.getHours();
        let minutes = time.getMinutes();
        let seconds = time.getSeconds();
        return year + '-' + this.addZero(month) + '-' + this.addZero(date) + ' ' +         this.addZero(hours) + ':' + this.addZero(minutes) + ':' + this.addZero(seconds);
      },

      addZero(num) {
        return num < 10 ? '0' + num : num
      },