<template> <div class="app-container"> <!-- $t is vue-i18n global function to translate lang --> <el-input style='width:340px;' :placeholder="$t('excel.placeholder')" prefix-icon="el-icon-document" v-model="filename"></el-input> <el-button style='margin-bottom:20px' type="primary" icon="document" @click="handleDownload" :loading="downloadLoading">{{$t('excel.selectedExport')}}</el-button> <el-table :data="list" v-loading.body="listLoading" element-loading-text="拼命加载中" border fit highlight-current-row @selection-change="handleSelectionChange" ref="multipleTable"> <el-table-column type="selection" align="center"></el-table-column> <el-table-column align="center" label='Id' width="95"> <template slot-scope="scope"> {{scope.$index}} </template> </el-table-column> <el-table-column label="Title"> <template slot-scope="scope"> {{scope.row.title}} </template> </el-table-column> <el-table-column label="Author" width="110" align="center"> <template slot-scope="scope"> <el-tag>{{scope.row.author}}</el-tag> </template> </el-table-column> <el-table-column label="Readings" width="115" align="center"> <template slot-scope="scope"> {{scope.row.pageviews}} </template> </el-table-column> <el-table-column align="center" label="PDate" width="220"> <template slot-scope="scope"> <i class="el-icon-time"></i> <span>{{scope.row.display_time}}</span> </template> </el-table-column> </el-table> </div> </template> <script> import { fetchList } from '@/api/article' export default { name: 'selectExcel', data() { return { list: null, listLoading: true, multipleSelection: [], downloadLoading: false, filename: '' } }, created() { this.fetchData() }, methods: { fetchData() { this.listLoading = true fetchList(this.listQuery).then(response => { this.list = response.data.items this.listLoading = false }) }, handleSelectionChange(val) { this.multipleSelection = val }, handleDownload() { if (this.multipleSelection.length) { this.downloadLoading = true import('@/vendor/Export2Excel').then(excel => { const tHeader = ['Id', 'Title', 'Author', 'Readings', 'Date'] const filterVal = ['id', 'title', 'author', 'pageviews', 'display_time'] const list = this.multipleSelection const data = this.formatJson(filterVal, list) excel.export_json_to_excel(tHeader, data, this.filename) this.$refs.multipleTable.clearSelection() this.downloadLoading = false }) } else { this.$message({ message: 'Please select at least one item', type: 'warning' }) } }, formatJson(filterVal, jsonData) { return jsonData.map(v => filterVal.map(j => v[j])) } } } </script>