Last active
June 28, 2016 03:32
-
-
Save xiaojue/8208878 to your computer and use it in GitHub Desktop.
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| var xlsx = require('node-xlsx'); | |
| var fs = require('fs'); | |
| var optimist = require('optimist').argv; | |
| var src = optimist.src; | |
| var target = optimist.target; | |
| var json = fs.readFileSync(src).toString(); | |
| String.prototype.decodeHTML = function() { | |
| var map = { | |
| "gt": ">", | |
| "nbsp": " ", | |
| "amp": "&" | |
| /* , … */ | |
| }; | |
| return this.replace(/&(#(?:x[0-9a-f]+|\d+)|[a-z]+);?/gi, function($0, $1) { | |
| if ($1[0] === "#") { | |
| return String.fromCharCode($1[1].toLowerCase() === "x" ? parseInt($1.substr(2), 16) : parseInt($1.substr(1), 10)); | |
| } else { | |
| return map.hasOwnProperty($1) ? map[$1] : $0; | |
| } | |
| }); | |
| }; | |
| var _GroupMember_Callback = function(data) { | |
| data = data.data.item; | |
| var ret = []; | |
| data.forEach(function(item, index) { | |
| var nick = item.nick.decodeHTML(); | |
| nick = nick.replace(/[^a-zA-Z0-9_\-\u4e00-\u9fa5]/g,''); | |
| ret.push([nick, item.uin + '@qq.com']); | |
| }); | |
| var worksheets = []; | |
| worksheets.push({ | |
| "name": "sheets", | |
| "data": ret | |
| }); | |
| var buffer = xlsx.build({ | |
| worksheets: worksheets | |
| }); // returns a buffer | |
| fs.open(target, 'w', function(err, fd) { | |
| if (err) throw err; | |
| else { | |
| fs.write(fd, buffer, 0, buffer.length, null, function() { | |
| if (err) throw err; | |
| else { | |
| fs.close(fd, function() { | |
| console.log(target+ ' written'); | |
| }); | |
| } | |
| }); | |
| } | |
| }); | |
| }; | |
| eval(json); |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| _GroupMember_Callback({ | |
| "code":0, | |
| "subcode":0, | |
| "message":"", | |
| "default":0, | |
| "data": | |
| {"alpha":0,"bbscount":0,"class":10026,"create_time":1387271346,"filecount":0,"finger_memo":"","group_memo":"昵称格式：城市名-昵称\u003cbr\u003eFiona彩妆资讯及课程：http:\/\/www.duobei.com\/site\/2634288283","group_name":"Fiona化妆教室","item":[{"iscreator":0,"ismanager":0,"nick":"vivianc&","uin":8340551},{"iscreator":0,"ismanager":0,"nick":"江西，小鱼","uin":184850548},{"iscreator":0,"ismanager":0,"nick":"浙江□暖暖","uin":270500320},{"iscreator":0,"ismanager":0,"nick":"米","uin":276456902},{"iscreator":0,"ismanager":0,"nick":"yoyo","uin":286560847},{"iscreator":0,"ismanager":0,"nick":"赵小亮亮","uin":330622452},{"iscreator":0,"ismanager":0,"nick":"Stephanie","uin":389041060},{"iscreator":0,"ismanager":1,"nick":"南京-Fiona","uin":398354830},{"iscreator":0,"ismanager":0,"nick":"-孀孀-","uin":499822094},{"iscreator":0,"ismanager":0,"nick":"困貓","uin":502037967},{"iscreator":0,"ismanager":0,"nick":"ζއއއޓ旧城","uin":755932257},{"iscreator":0,"ismanager":0,"nick":"北京-刘岩","uin":814148876},{"iscreator":0,"ismanager":0,"nick":"没人爱更要爱自己","uin":840113129},{"iscreator":0,"ismanager":0,"nick":"广东、宠","uin":897048178},{"iscreator":0,"ismanager":0,"nick":"探戈橙","uin":965470312},{"iscreator":0,"ismanager":0,"nick":"sooki cat","uin":971723518},{"iscreator":0,"ismanager":0,"nick":"时光谎言゛ sea","uin":1019881477},{"iscreator":0,"ismanager":0,"nick":"浙江-雪儿","uin":1048527903},{"iscreator":0,"ismanager":0,"nick":"武汉—豆芽梦","uin":1083533757},{"iscreator":0,"ismanager":0,"nick":"妖孽只在夜里哭","uin":1103429016},{"iscreator":0,"ismanager":0,"nick":"广东-嘉嘉","uin":1115118239},{"iscreator":0,"ismanager":0,"nick":"广东-榕榕","uin":1150596409},{"iscreator":0,"ismanager":0,"nick":"玩蛋去！","uin":1198038909},{"iscreator":0,"ismanager":0,"nick":"广州-丫丫","uin":1215627324},{"iscreator":0,"ismanager":0,"nick":"可爱缺口的另一半是坚强","uin":1253610467},{"iscreator":0,"ismanager":0,"nick":"施昭蒂","uin":1255348293},{"iscreator":0,"ismanager":0,"nick":"娇纵","uin":1285984952},{"iscreator":0,"ismanager":0,"nick":"吾̶家̶哥̶哥̶坏̶坏̶","uin":1334665366},{"iscreator":0,"ismanager":0,"nick":"小情绪-_,","uin":1378973354},{"iscreator":0,"ismanager":0,"nick":"罂粟。湖南","uin":1427271561},{"iscreator":0,"ismanager":0,"nick":"内蒙---晓特","uin":1452546911},{"iscreator":0,"ismanager":0,"nick":"肉包子打狗——有去无回","uin":1466206488},{"iscreator":0,"ismanager":0,"nick":"唯爱。白贤","uin":1509390760},{"iscreator":0,"ismanager":0,"nick":"· 毒领瘋骚ζ。","uin":1565884362},{"iscreator":0,"ismanager":0,"nick":"内蒙---楠","uin":1603970439},{"iscreator":1,"ismanager":0,"nick":"北京-CC","uin":1619257970},{"iscreator":0,"ismanager":0,"nick":"爱咳嗽 평생 선서","uin":1633645800},{"iscreator":0,"ismanager":0,"nick":"|▍尘世如戏丶逢场做戏","uin":1757543650},{"iscreator":0,"ismanager":0,"nick":"旧瘾゜ゝ","uin":1758948650},{"iscreator":0,"ismanager":0,"nick":"江苏—咒蓝","uin":1791349744},{"iscreator":0,"ismanager":0,"nick":"╭活茴、曾经的自己","uin":1909865399},{"iscreator":0,"ismanager":0,"nick":"蛋蛋 碎了","uin":1933613371},{"iscreator":0,"ismanager":0,"nick":"哎耶。","uin":1945135403},{"iscreator":0,"ismanager":0,"nick":"甘肃---夏清淼","uin":1964547195},{"iscreator":0,"ismanager":0,"nick":"抬头触摸那一抹阳光","uin":1982683097},{"iscreator":0,"ismanager":0,"nick":"甘肃 --兰州","uin":2226981075},{"iscreator":0,"ismanager":0,"nick":"宁波-翡翠","uin":2238526533},{"iscreator":0,"ismanager":0,"nick":"╰M U﹊","uin":2357273665},{"iscreator":0,"ismanager":0,"nick":"重庆-浔浔","uin":2403741285},{"iscreator":0,"ismanager":0,"nick":"吊儿郎当好少年","uin":2441775322},{"iscreator":0,"ismanager":0,"nick":"らforget゜旧事","uin":2445016395},{"iscreator":0,"ismanager":0,"nick":"你会发光呀！","uin":2455164253},{"iscreator":0,"ismanager":0,"nick":"猛汉子@","uin":2501839324},{"iscreator":0,"ismanager":0,"nick":"宁儿","uin":2567450887},{"iscreator":0,"ismanager":0,"nick":"干嘛 回忆过去","uin":2591054506},{"iscreator":0,"ismanager":0,"nick":"______夏瑾汐","uin":2593505968},{"iscreator":0,"ismanager":0,"nick":"半城烟沙、忆素颜","uin":2858602420},{"iscreator":0,"ismanager":0,"nick":"心似莲花","uin":2871284783}],"level":0,"nick":"CC","option":2,"total":58}} | |
| ); |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment