前言
之前写个js导出excel的方法,但是发现已经过时了,最近用了一下新的导出方式,可以用,现在分享一下。vue,react都可以用。原理就是通过table导出excel
方法一:
通过csv的方式导出
exportExcel() { // 前端导出excel
const types = { ‘DYNAMIC’: ‘动态创意’, ‘STATIC’: ‘静态创意’, ‘VIDEO’: ‘视频创意’, ‘MATERIAL’: ‘素材创意’ }
let currentGroup = ‘’
let exportData = this.showList.map(item => {
if (item.currentGroup) {
currentGroup = item.currentGroup
}
return {
creativeId: item.creativeId,
creativeName: item.creativeName,
description: item.description&& item.description.replace(/[\n\t\r,]/g,";"),// 把里面的回车和中文逗号换成分号
creativeSize: ${item.creativeWidth}*${item.creativeHeight}
,
creativeTime: this.getTime(item.startDate) + ’ - ’ + this.getTime(item.endDate),
creativesourceTyle: this.showType(item.creativeSource),
creativeTypename: types[item.creativeType]