//参数说明:jsonData jsonData, FileName 要导出的文件名 ,ShowLabel = 表头function export2Excel(jsonData, FileName, ShowLabel) { if(jsonData=='' || jsonData == null){ alert("暂无数据无法导出!"); return; } if(FileName=='' || FileName == null){ alert("文件名设置错误!"); return; } if(ShowLabel=='' || ShowLabel == null){ alert("表头为空无法导出!"); return; } var excel = '
'; //生成表头 var row = " "; for (var i = 0; i < ShowLabel.length; i++) { row += " " + ShowLabel[i] + ' | '; } excel += row + "
"; //循环生成表身 for (var i = 0; i < jsonData.length; i++) { var row = " "; for (var j in jsonData[i]) { var td = jsonData[i][j]; row += ' ' + td + ' | '; } excel += row + "
"; } excel += "
"; console.log(excel); //组装excel var excelFile = ""; excelFile += '
'; excelFile += '
'; excelFile += ""; excelFile += "
"; excelFile += ""; excelFile += ""; excelFile += excel; excelFile += ""; excelFile += ""; var uri = 'data:application/vnd.ms-excel;charset=utf-8,' + encodeURIComponent(excelFile); var link = document.createElement("a"); link.href = uri; link.style = "visibility:hidden"; link.download = FileName+".xls"; document.body.appendChild(link); link.click(); document.body.removeChild(link); }