史无前例之---NodeJs 中读取OracleDB 数据，将data 生成 Excel文件

/** * Created by json on 2017/6/5. * 推介使用：excel-export * 根据data ,JSON.parse(data)---<data=JSON.stringify(result)> *     设置 Excel conf.cols and  conf.rows ,文件name ,savePath,生成Excel */var excelExport = require('excel-export');//excel 操作var fs = require('fs');//文件操作var guid = require('guid');//guidvar path = require('path');//路径问题/* var params=[ {"id":100017,"name":"邹","tel":"18192427327"}, {"id":100030,"name":"喜","tel":"18192427327"}, {"id":100018,"name":"峰","tel":"10086100862"} ]; */function CreateExcel(param) {    var conf = {};    conf.cols = [];    conf.rows = [];    // console.log(typeof param)    var params = JSON.parse(param);    console.log(param[0]);    //设置 clos 列名    for (i in params[0]) {        conf.cols.push({            caption: i, type: 'string', width: 16        })    }//设置 rows  行数据    for (var j in params) {        var row = [];//key        for (var i in params[j]) {            row.push(params[j][i]);        }        conf.rows.push(            row        );    }    // console.log(conf.rows);    // console.log(conf.cols);    var result = excelExport.execute(conf);    var gid = guid.create();    // var name=gid+".xlsx";    var name = gid + ".xls";    var saveDirPath = "./modules/zxf_test/CreateExcels/";    var filePath = path.resolve(saveDirPath + name);    fs.writeFile(filePath, result, 'binary', function (err) {        if (err) {            console.error("异常：" + err);        }        console.log("新生成Excel路径filePath--->" + filePath);    });    return "create excel ok ";}//抛module.exports = {    CreateExcel: CreateExcel};