exportData() {
const rows = [{街道:'xxx',相关人数:1},{街道:'xx',相关人数:2},{街道:'x',相关人数:3},{街道:'xxxxx',相关人数:1111}]
// this.tableData.data.records.forEach((data) => {
// const entry = {}
// this.tableData.header.forEach((header) => {
// entry[header.label] = data[header.prop]
// })
// rows.push(entry)
// })
console.log(rows)
const worksheet = XLSX.utils.json_to_sheet(rows)
const workbook = XLSX.utils.book_new()
XLSX.utils.book_append_sheet(workbook, worksheet, 'Sheet1')
const fileBuffer = XLSX.write(workbook, {
type: 'array',
bookType: 'xlsx'
})
this.saveFile(fileBuffer, '人口筛选.xlsx')
},
// 保存数据并且导出
saveFile(buffer, fileName) {
const blob = new Blob([buffer], { type: 'application/octet-stream' })
const link = document.createElement('a')
link.href = URL.createObjectURL(blob)
link.download = fileName
link.click()
this.$message({
message: '下载成功',
type: 'success'
})
},
06-07
1824
07-28