首页 > 其他 > 详细

前端导出excel

时间:2020-07-21 21:24:03      阅读:71      评论:0      收藏:0      [点我收藏+]
function base64(content) { return window.btoa(unescape(encodeURIComponent(content))); } function tableToExcel(tableID, fileName) { var excelContent = $("#" + tableID).html(); // alert(excelContent); var excelFile = "<html xmlns:o=‘urn:schemas-microsoft-com:office:office‘ xmlns:x=‘urn:schemas-microsoft-com:office:excel‘ xmlns=‘http://www.w3.org/TR/REC-html40‘>"; excelFile += "<head><!--[if gte mso 9]><xml><x:ExcelWorkbook><x:ExcelWorksheets><x:ExcelWorksheet><x:Name>{worksheet}</x:Name><x:WorksheetOptions><x:DisplayGridlines/></x:WorksheetOptions></x:ExcelWorksheet></x:ExcelWorksheets></x:ExcelWorkbook></xml><![endif]--></head>"; excelFile += "<body><table width=‘10%‘ border=‘1‘>"; excelFile += excelContent; excelFile += "</table></body>"; excelFile += "</html>"; var link = "data:application/vnd.ms-excel;base64," + base64(excelFile); var a = document.createElement("a"); a.download = fileName + ".xlsx"; a.href = link; a.click(); }

前端导出excel

原文:https://blog.51cto.com/brightaries/2512167

(0)
(0)
   
举报
评论 一句话评论(0
关于我们 - 联系我们 - 留言反馈 - 联系我们:wmxa8@hotmail.com
© 2014 bubuko.com 版权所有
打开技术之扣,分享程序人生!