vue实现导出功能

依赖elementui实现导出

1、下载依赖包

npm install --save xlsx file-saver

2、使用

<template>
    <div>
        <!-- 导出按钮 -->
        <el-button  @click="daoChu" type="primary">导出</el-button>
        
        <el-table
            class="table"
            :data="tableData"
            border
            style="width: 100%">
            <el-table-column
            prop="date"
            label="日期"
            width="180">
            </el-table-column>
            <el-table-column
            prop="name"
            label="姓名"
            width="180">
            </el-table-column>
            <el-table-column
            prop="address"
            label="地址">
            </el-table-column>
        </el-table>
    </div>
</template>
<script>
import FileSaver from "file-saver";
import XLSX from "xlsx";
export default {
  data() {
    return {
        tableData: [{
          date: '2016-05-02',
          name: '王小虎',
          address: '上海市普陀区金沙江路 1518 弄'
        }, {
          date: '2016-05-04',
          name: '王小虎',
          address: '上海市普陀区金沙江路 1517 弄'
        }, {
          date: '2016-05-01',
          name: '王小虎',
          address: '上海市普陀区金沙江路 1519 弄'
        }, {
          date: '2016-05-03',
          name: '王小虎',
          address: '上海市普陀区金沙江路 1516 弄'
        }]
    };
  },
  methods: {
    daoChu() {
     //  .table要导出的是哪一个表格
      var excelDom = XLSX.utils.table_to_book(document.querySelector(".table"));
      var excelType = XLSX.write(excelDom, {
        bookType: "xlsx",
        bookSST: true,
        type: "array",
      });
      try {
        //  name+'.xlsx'表示导出的excel表格名字
        FileSaver.saveAs(
          new Blob([excelType], { type: "application/octet-stream" }),"导出的表格名称.xlsx"
        );
      } catch (e) {
        if (typeof console !== "undefined");
      }
      return excelType;
    }
  }
};
</script>