1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
| <template>
| <div class="table">
| <div class="about">
| <el-button @click="downExcel">下载</el-button>
| <el-table id="table" :data="tableData" stripe 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>
| <el-pagination background layout="prev, pager, next" :total="1000">
| </el-pagination>
| </div>
| </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: {
| downExcel() {
| let et = XLSX.utils.table_to_book(document.getElementById("table"));
| let etout = XLSX.write(et, {
| bookType: "xlsx",
| bookSST: true,
| type: "array"
| });
| try {
| FileSaver.saveAs(
| new Blob([etout], {
| type: "application/octet-stream"
| }),
| `表.xlsx`
| ); //导出的文件名
| } catch (e) {
| console.log(e, etout);
| }
| return etout;
| }
| },
| mounted() {}
| };
| </script>
| <style>
| .table {
| height: 100%;
| width: 1005;
| display: none;
| }
| </style>
|
|
