/** * Created by Tony on 2017/3/28. */ var nodeExcel = require('excel-export'); //关联excel-export模块 var conf = {}; conf.cols = [ {caption:'采购编号', type:'string'}, {caption:'合同名称', type:'string'}, {caption:'甲方', type:'string'}, {caption:'甲方部门', type:'string'}, {caption:'乙方', type:'string'}, {caption:'乙方部门', type:'string'}, {caption:'签订日期', type:'date'}, {caption:'中标日期', type:'date'}, {caption:'结束日期', type:'date'}, {caption:'销售负责人', type:'string'}, {caption:'商务负责人', type:'string'}, {caption:'业绩归属部门', type:'string'}, {caption:'金额', type:'number'}, {caption:'状态', type:'string'} ]; var data = [{myId: 0, name: "dummy name", partyA: "", partyADept: "", partyB:"", partyBDept: "", signDate: "", beginDate:"", endDate:"", amount: 100, state:"dummy!"}] var m_data = []; var arry = [data[0].myId, data[0].name, data[0].partyA, data[0].partyADept, data[0].partyB, data[0].partyBDept, data[0].signDate, data[0].beginDate, data[0].endDate, "销售负责人", "商务负责人", "业绩归属部门", data[0].amount, data[0].state ]; m_data[0] = arry; conf.rows = m_data; var result = nodeExcel.execute(conf); console.log(result);