导出cvs 表格
/* 数据data从后端返回 */
storageObj= {
title: ['q','w中文'],//表的标题
titleForKey: ['o','g'],//表的字段名
data: [{ //表的数据
o:'1',
g:'2'
},
{
o:'3',
g:'4'
},
]
}
//导出csv
const exportCsv = (storageObj: any) => {
let title = storageObj.title
let titleForKey = storageObj.titleForKey
let data = storageObj.data
let str = []
str.push(storageObj.title.join(',')+'\n')
for(let i = 0; i < data.length; i++) {
let temp = []
for(let j = 0; j < titleForKey.length; j++) {
temp.push(data[i][titleForKey[j]])
}
str.push(temp.join(',')+'\n')
}
let uri = 'data:text/csv;charset=utf-8,\ufeff' + encodeURIComponent(str.join(''))
let downloadLink = document.createElement('a')
downloadLink.href = uri
downloadLink.download = new Date().toISOString().substring(0,10)+'.csv'
document.body.appendChild(downloadLink)
downloadLink.click()
document.body.removeChild(downloadLink)
}