遇到的问题:
1. 含有逗号(,)
问题描述:因为csv是一种通用的、相对简单的逗号分隔值文件格式,含有, 的字符串导出会根据,分开,占据不同单元格
解决办法:我们可以把数据格式从 kakakak ,alakk 处理成 "kakakak ,alakk" 就好,用双引号包裹
2. 含有双引号(")
问题描述:如果该字段中有双引号,csv解析会出问题
解决办法:该双引号前要再加一个双引号,然后把该字段使用双引号括起来。eg:(lalla"123=>"lalla""123")
方法:
const exportCsv = (data) => {
let title = CSV_TITLE
let titleForKey = CSV_TITLE
let str = []
str.push(title.join(',') + '\n') //标题
for (let i = 0; i < data.length; i++) {
let temp = []
for (let j = 0; j < titleForKey.length; j++) {
if (typeof data[i][titleForKey[j]] === 'object') {
//若有值为对象则push undefined,看项目具体需求
temp.push(undefined)
} else {
let value = data[i][titleForKey[j]]
if (typeof value === 'string') { //导出字符串含有,/"时
value = `"${value.replace(/"/g, '""')}"`
}
temp.push(value)
}
}
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().toLocaleDateString()}.csv`
document.body.appendChild(downloadLink)
downloadLink.click()
document.body.removeChild(downloadLink)
}