史无前例之---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');//guid
var 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
};