需求:
用js实现从如下word文件中,导出聊天记录中出现过的人名并统计出现次数到excel
结果:
JS实现:
const fs = require('fs')
const json2xls = require('json2xls')
let file = fs.readFileSync('./word.txt', 'utf-8')
console.log(file)
const reg = /(?<=\d-)[\u4e00-\u9fa5]*(?=\s)/gi
const a = file.match(reg)
const obj = {}
a.forEach((item) => {
if (obj[item]) obj[item]++
else obj[item] = 1
})
const xls = json2xls(obj)
fs.writeFileSync('ttt.xlsx', xls, 'binary')