/**
* 导出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;
};