Nodejs的模版中有很多关于Excel表格的，这里我简单介绍一下我使用过的一个模块的使用。

首先，先安装Excel的模块:

npm install node-xlsx

然后，在代码中引入模块：

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

最后，获取数据并写入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 部分的代码：

var https = require("https");  var http = require("http");  var Url = require("url");  var querystring = require('querystring');    // 默认值  var defaultSetting = {      // 如果返回false可以取消本次请求      beforeSend: function (req) {      },      complete: function (req) {      },      data: '', // Object, String      dataType: 'JSON',      error: function () {      },      headers: {}, // {k:v, ...}      statusCode: {},      success: function (data) {      },      timeout: 10,      type: 'GET', // GET, POST      url: "www.baidu.com"  };    /** * */  function ajax(settings) {      // ajaxlbs.js(settings)      if (typeof settings === "object") {          // 处理默认值继承          // todo ...          for (key in defaultSetting) {              if (settings[key] == null) {                  settings[key] = defaultSetting[key];              }          }      }        var params = Url.parse(settings.url, true);      // params 解析出来的参数如下      // {      // "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 === "json") {                      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;

生成的Excel内容：

代码下载地址：http://download.csdn.net/detail/qxs965266509/8896431

如有转载请著名来自http://blog.csdn.net/qxs965266509