JS 在页面上直接将json数据导出到excel，支持chrome,edge,IE10+,IE9,IE8,Safari,Firefox
<html> <head> </head> <body> <script type="text/javascript"> function jsexport(){ var jsonData = [{name:"张三", sex:"男", age:46},{name:"李四", sex:"男", age:20},{name:"王五", sex:"男", age:33},{name:"赵六", sex:"男", age:80}]; var GridData = JSON.parse(JSON.stringify(jsonData)) JSONToCSV(GridData, "UserReport.csv", true); } var blob; var filename; function c(){ window.navigator.msSaveOrOpenBlob(blob, filename); } function JSONToCSV(JSONData, ReportName, ShowLabel) { var arrData = typeof JSONData != 'object' ? JSON.parse(JSONData) : JSONData; var CSV = ''; if (ShowLabel) { var row = ""; for (var index in arrData[0]) { row += index + ','; } row = row.slice(0, -1); CSV += row + '\r\n'; } for (var i = 0; i < arrData.length; i++) { var row = ""; for (var index in arrData[i]) { row += '"' + arrData[i][index] + '",'; } row.slice(0, row.length - 1); //add a line break after each row CSV += row + '\r\n'; console.log(CSV); } if (CSV == '') { alert("数据有错误"); return; } var link = document.createElement("a"); link.id="lnkDwnldLnk"; link.name="lnkDwnldLnk"; link.setAttribute("style", "display:none"); var ifdo = document.createElement("iframe"); ifdo.id="ifdiframe"; ifdo.name="ifdiframe"; ifdo.setAttribute("style", "display:none"); document.body.appendChild(link); document.body.appendChild(ifdo); var csv = CSV; try { blob = new Blob([csv], { type: 'text/txt' }); } catch (e) { blob = [csv]; } var csvUrl = ""; filename = ReportName; if (window.navigator.userAgent.indexOf("Chrome") >= 1 || window.navigator.userAgent.indexOf("Safari") >= 1) { csvUrl = window.webkitURL.createObjectURL(blob); link.setAttribute("download", filename); link.setAttribute("href", csvUrl); link.click(); } if (window.navigator.userAgent.indexOf("Firefox") >= 1) { csvUrl = window.URL.createObjectURL(blob); link.setAttribute("download", filename); link.setAttribute("href", csvUrl); link.click(); } else { if(window.navigator.msSaveOrOpenBlob) { //IE>=10 link.addEventListener('click', function() { window.navigator.msSaveOrOpenBlob(blob, filename); }); link.click(); } else { //支持IE9、IE8; IE7及以下暂不支持，因为不支持JSON var ifd = document.getElementById('ifdiframe').contentDocument; ifd.open('text/plain', 'replace'); ifd.write('\r\n\r\n' + csv); ifd.close(); ifd.execCommand('SaveAs', null, filename); } } document.body.removeChild(link); document.body.removeChild(ifdo); } </script> <input type="Button" id="bygen" value="导出" οnclick="jsexport()"/ > <br> <a id="mydownload" name="mydownload" href="#" >导出</a> </html>
纯原生js代码，本人原创，未经许可可随意转载
