我在设置自动宽度时遇到问题。我想将所有文本放在一个单元格中,无需进一步点击即可查看所有值。我导出的 CSV 目前看起来像这样:
以下是我想要实现的目标:
到目前为止我尝试过的是,转换这个数据数组(字符串化)
[
["Play Date","Round","Result Virtual","Result Data"],
["=\"2020-03-04 00:48:00\"","16","\"[LEFT, LINE3, EVEN]\"","\"[LEFT, LINE3, EVEN]\""],
["=\"2020-03-04 00:51:00\"","17","\"[LEFT, LINE4, ODD]\"","\"[LEFT, LINE4, ODD]\""],
["=\"2020-03-04 00:54:00\"","18","\"[LEFT, LINE3, EVEN]\"","\"[LEFT, LINE3, EVEN]\""],
["=\"2020-03-04 00:57:00\"","19","\"[RIGHT, LINE4, EVEN]\"","\"[RIGHT, LINE4, EVEN]\""]
]
转换成 CSV 格式,然后下载:
data.forEach(rowItem => {
rowItem.forEach(colItem => {
csvString += `${colItem},`
})
csvString += '\r\n'
})
csvString = 'data:application/csv,' + encodeURIComponent(csvString)
var x = document.createElement('A')
x.setAttribute('href', csvString)
x.setAttribute('download', `${new Date()}.csv`)
document.body.appendChild(x)
x.click()
浮云间
交互式爱情
相关分类