前端基于XLSX实现数据导出到Excel表格
1、安装XLSX
npmi nstall --save xlsx
2、引用并生成xlsx
import XLSX from 'xlsx'
//方法1
downloadExcelTemplate(){
let sheetName = '批量导入用户模板'
const ws = XLSX.utils.aoa_to_sheet([["用户标识","用户姓名","用户手机号","用户邮箱号码"]])
const wb = XLSX.utils.book_new()
XLSX.utils.book_append_sheet(wb,ws, sheetName)
XLSX.writeFile(wb, sheetName + '.xlsx')
}
//方法2
downloadExcelTemplate(){
let sheetName = '批量导入用户模板'
const ws = XLSX.utils.json_to_sheet([{"用户标识":"","用户姓名":"","用户手机号":"","用户邮箱号码":""}])
const wb = XLSX.utils.book_new()
XLSX.utils.book_append_sheet(wb,ws, sheetName)
XLSX.writeFile(wb, sheetName + '.xlsx')
}
注意:方法1和方法2主要区别是一个是数组格式、一个是JSON格式。