/** * 导出excel按钮 */ OaGdzcPdreport.exportExcel = function () { console.info(OaGdzcPdreport.initColumn()); return false; queryData[‘limit’] = -1; $.ajax({ url: Feng.ctxPath + ‘/oaGdzcPdreport/list’, //所需要导出的 数据路径 type: ‘post’, data: queryData, async: false, dataType: ‘json’, success: function (res) { res.data.unshift({dh: ‘单号’,nd: ‘年度’, yf: ‘月份’}); //设置属性对应excel的列名 var data=excel.filterExportData(res.data,[‘dh’,‘nd’,‘yf’] //对应要导出的属性放在res.data,[‘dh’,‘nd’,‘yf’]数组里面 ); excel.exportExcel({ sheet1: data }, ‘导出的文件名.xlsx’, ‘xlsx’); }
}); queryData['limit'] = tableResult.config.limit; };