使用JS导出Excel，js通用模板

最新推荐文章于 2024-04-08 15:34:41 发布

暴走的Aluuubbarrrr

最新推荐文章于 2024-04-08 15:34:41 发布

阅读量677

点赞数

分类专栏：前端 xxxzy 文章标签： excel js 导出Excel js插件

本文链接：https://blog.csdn.net/qq_37162090/article/details/103508563

版权

前端同时被 2 个专栏收录

23 篇文章 0 订阅

订阅专栏

xxxzy

7 篇文章 0 订阅

订阅专栏

// 点击导出按钮
$("#exportExcel").click(function(){
	var fileName = $("#tableName").text();// 获取表格名称
    var table = document.getElementById("excelTable");// 通过id获取
    var excelContent = table.innerHTML;
    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>";
    excelFile += excelContent.replace(/\n/g,"<br style='mso-data-placement:same-cell;'/>") ;
    excelFile += "</table></body>";
    excelFile += "</html>";
    var link = "data:application/vnd.ms-excel;base64," + base64(excelFile);
    var a = document.createElement("a");
    a.download = fileName+".xls";
    a.href = link;
    a.click();
});

function base64 (content) {
    return window.btoa(unescape(encodeURIComponent(content)));
}