vue
<el-button
size="small"
style="margin-left:30px"
@click="exportPathMethod"
type="primary"
>样例下载</el-button>
js
exportPathMethod() {
/*
*注:csv文件:","逗号换列,\n换行,\t防止excel将长数字变科学计算法等样式
*/
//要导出的json数据
let tableData:any = [{
ip:'127.0.0.1',
domain:'localhost',
md5:'b80a2da6b087eacee17d7510a28fcd83',
url:'http://localhost'
}]
let _self = this
//## 数据处理
//一级表
let mainTitle:any = ["ip","domain","md5","url"];//一级标题
let mainTitleForKey:any = ["ip","domain","md5","url"];//一级过滤
let mainList = tableData;//一级数据
let mainStr = [];
mainStr.push(mainTitle.join("\t,")+"\n"); //标题添加上换列转成字符串并存进数组
for(let i=0;i<tableData.length;i++){
let temp = [];
for(let j=0;j<mainTitleForKey.length;j++){
temp.push(tableData[i][mainTitleForKey[j]]); //根据过滤器拿出对应的值
}
mainStr.push(temp.join("\t,")+"\n"); //取出来的值加上逗号换列转字符串存数组
}
// console.log(JSON.stringify(mainStr.join("")));//打印文本
//两个表数组转成字符串合并
let merged = mainStr.join("")
//console.log(JSON.stringify(merged));//打印结果
//## 导出操作
// encodeURIComponent解决中文乱码
const uri = 'data:text/csv;charset=utf-8,\ufeff' + encodeURIComponent(merged)
// 通过创建a标签实现
let link = document.createElement('a')
link.href = uri
// 对下载的文件命名
link.download = 'white-list-example.csv'
document.body.appendChild(link)
link.click()
}