Nodejs retrieves network data and generates an Excel table

Nodejs retrieves network data and generates an Excel table

The node. js template contains many Excel tables. Here I will briefly introduce the use of a module I have used.

First, install the Excel module:

npm install node-xlsx

Then, introduce the module in the Code:

var xlsx = require('node-xlsx');

Finally, get the data and write it into Excel:

var fs = require('fs');var xlsx = require('node-xlsx');var ajax = require('./ajax.js');start();function start() {    ajax.ajax({        url: http://yuntuapi.amap.com/datamanage/data/list,        type: GET,        data: {            tableid: XXX,//53eacbe4e4b0693fbf5fd13b            key: XXX        },        success: function (data) {            var myDatas = [];            var datas = (JSON.parse(data)).datas;            var count = 0;            for (var index in datas) {                var account = datas[index];                var colum = [];                var names;                if (index == 0) {                    names = [];                }                for (var index2 in account) {                    if (index == 0)                        names.push(index2);                    var value = account[index2];                    if (value == null) {                        value = ;                    }                    colum.push(value);//                    console.log(account);                }                if (index == 0) {                    myDatas.push(names);                }                myDatas.push(colum);                if (index == datas.length - 1) {                    writeXls(myDatas);                }            }            console.log(myDatas.length);        }    });}function writeXls(datas) {    var buffer = xlsx.build({worksheets: [        {name: Group, data: datas}    ]});    fs.writeFileSync(Group.csv, buffer, 'binary');}function parseXls() {    var obj = xlsx.parse('myFile.xlsx');    console.log(obj);}

Ajax code:

Var https = require (https); var http = require (http); var Url = require (url); var querystring = require ('querystring '); // default value var defaultSetting = {// if false is returned, you can cancel this request beforeSend: function (req) {}, complete: function (req) {}, data :'', // Object, String dataType: 'json', error: function () {}, headers :{}, // {k: v ,...} statusCode :{}, success: function (data) {}, timeout: 10, type: 'get', // G ET, POST url: www.baidu.com};/*****/function ajax (settings) {// ajaxlbs. js (settings) if (typeof settings = object) {// process default value inheritance // todo... for (key in defaultSetting) {if (settings [key] = null) {settings [key] = defaultSetting [key] ;}} var params = Url. parse (settings. url, true); // The parameters parsed by params are as follows // {// protocol: http:, // slashes: true, // host: localhost: 3000, // port: 3000, // hostname: Localhost, // href: http: // localhost: 3000 /? D = 1, // search :? D = 1, // query: {d: 1}, // pathname:/, // path :/? D = 1 //} var options = {host: params. hostname, port: params. port | 80, path: params. path, method: settings. type}; if (settings. data! = Null) {options. path + =? For (var key in settings. data) {options. path = options. path + & + key + = + settings. data [key];} console. log (options. path);} var httpUnity = http; if (params. protocol = https :) {options. port = 443; var httpUnity = https;} var req = httpUnity. request (options, function (res) {var data = ''; res. on ('data', function (chunk) {data + = chunk ;}). on ('end', function () {if (settings. dataType = jso N) {try {data = JSON. parse (data) ;}catch (e) {data = null ;}} settings. success (data); settings. complete (req );});}). on ('error', function (e) {settings. error (e) ;}); // if (typeof settings. beforeSend === function) {// if (! Settings. beforeSend (req) {// settings. complete (req); // req. end (); // return false; //} if (settings. type = POST) {var dataStr = querystring. stringify (settings. data); req. setHeader (Content-Length, dataStr. length); req. write (dataStr);} req. setTimeout (settings. timeout); req. end ();} exports. ajax = ajax;

Generated Excel content: