npm install ejej = export json to csv
我们使用mongodb会经常导出json
mongoexport -d xbm-wechat-api -c senddeliveryhistories -o senddeliveryhistories.json --jsonArray --query "{date:{\$in:['20150821','20150822']}}"
但json转成csv又没有上面的header，如果使用json2csv这样库，又无法解决对象嵌套的取值问题，所以就写了ej这个工具，它可以直接把mongoexport导出的json直接转成csv
比如
``
[
{
"__v": 0,
"_id": {
"$oid": "55bf208846b246fa238ff4d7"
},
"created_at": {
"$date": "2015-08-03T08:04:24.648Z"
},
"date": "20150803",
}
]
会生成以下4列
- __v
- _id.$oid
- created_at.$date
- date
[sudo] npm install -g ej
ej input.json output.csv
1. Fork it
2. Create your feature branch (git checkout -b my-new-feature)git commit -am 'Add some feature'
3. Commit your changes ()git push origin my-new-feature
4. Push to the branch ()
5. Create new Pull Request
- v1.0.0 初始化版本,实现ej导出
- write by i5ting` shiren1118@126.com
如有建议或意见，请在issue提问或邮件
this repo is released under the MIT
License.