<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="UTF-8">
<title>Title</title>
<script src="https://cdn.bootcss.com/d3/5.9.2/d3.min.js"></script>
</head>
<body>
<script>
//将excel保存为csv格式,再用文本文件打开,将编码设为utf8
async function init() {
let data1 = await d3.csv('soures.csv')
let data2 = await d3.csv('result.csv')
//在txt中将列表头复制出来
const key = 'name_path,name,mine_id,mine_code,state,实时数据,是否接入'
const keyArr = key.split(',')
let result = key + '\n'
//匹配另一张表的对应列,组装成新表输出
data2.forEach((item)=>{
item['是否接入'] = ''
for (let i = 0; i < data1.length; i++) {
let item2 = data1[i]
if(item.mine_code === item2['尾矿库编号']) {
item['是否接入'] = item2['是否接入'];
break
}
}
keyArr.forEach(k=>{
result +=item[k]+','
})
result +='\n'
})
console.log(result)//在浏览器控制台中查看输出的结果,直接粘贴到txt中,将后缀改为csv即可;
}
init()
</script>
</body>
</html>
07-14
2607
![](https://csdnimg.cn/release/blogv2/dist/pc/img/readCountWhite.png)
“相关推荐”对你有帮助么?
-
非常没帮助
-
没帮助
-
一般
-
有帮助
-
非常有帮助
提交