var resultsData = require('./results.json'); //results.json是数据源
var itemArray = [];
resultsData.forEach(function(oneUrl) {
oneUrl.results.forEach(function(item) {
var obj = {};
var myGroupLine = [];
if (item.groupLine) {
myGroupLine = item.groupLine.replace(/位成员/g,'').split('· ');
}
obj.pageUrl = oneUrl.url;
obj.groupUrl = item.groupUrl;
obj.name = item.name;
obj.type = (myGroupLine[0] || '').trim();
obj.members = (myGroupLine[1] || '').trim();
obj.posts = (myGroupLine[2] || '').trim();
obj.descLine = item.descLine;
itemArray.push(obj);
});
});
//console.log(itemArray);
var jsoncsv = require('json-csv');
var fs = require("fs");
var es = require("event-stream");
var options = {
fields: [{
name: 'pageUrl',
label: 'PageUrl',
},
{
name: 'groupUrl',
label: 'GroupUrl',
},
{
name: 'name',
label: 'Name',
},
{
name: 'type',
label: 'Type',
},
{
name: 'members',
label: 'Members',
},
{
name: 'posts',
label: 'Posts',
},
{
name: 'descLine',
label: 'DescLine',
}
]
}
var out = fs.createWriteStream("results.csv", { encoding: 'utf8' });
var readable = es.readArray(itemArray);
readable
.pipe(jsoncsv.csv(options))
.pipe(out)
将数据下载导出为CSV文件
最新推荐文章于 2022-06-08 02:16:24 发布