jsp:
<a οnclick="exportExcel()" id="export" class="ui-btn">导出</a></span>
js:
function exportExcel() { var data = JSON.stringify($('#grid').datagrid('getData').rows); console.log(data); if (data == '') return; JSONToCSVConvertor(data, "计划单列表", true); } function JSONToCSVConvertor(JSONData, ReportTitle, ShowLabel) { var unixTimestamp = new Date(form.billDate); var arrData = typeof JSONData != 'object' ? JSON.parse(JSONData) : JSONData; var CSV = ''; CSV += ReportTitle + '\r\n\n'; if (ShowLabel) { row = row.replace(/createTime/g, "创建时间").replace(/updateTime/g,"更新时间").replace(/updateBy/g, "更新人").replace(/deleted/g,"订单删除标志").replace(/ver/g, "版本号").replace(/product/g,"商品名称") .replace(/qty/g, "质量").replace(/weight/g,"重量").replace(/index/g,"序号"); row = row.slice(0, -1); CSV += row + '\r\n'; } for (var i = 0; i < arrData.length; i++) { var row = form.billNo+","+form.stock.name+","+unixTimestamp.format("yyyy-MM-dd")+","; for ( var index in arrData[i]) { if (arrData[i].id == undefined){ //去除空行 row = ""; break; } row += '"' + arrData[i][index] + '",'; } row.slice(0, row.length - 1); CSV += row + '\r\n'; } if (CSV == '') { alert("Invalid data"); return; } var fileName = "MyReport_"; fileName += ReportTitle.replace(/ /g, "_"); var uri = 'data:text/csv;charset=utf-8,' + encodeURI(CSV); var link = document.createElement("a"); link.href = uri; link.style = "visibility:hidden"; link.download = fileName + ".csv"; document.body.appendChild(link); link.click(); document.body.removeChild(link); }