js把table内容导出成excel

从别处摘抄来比较简单的方法（忘记出处是哪里了，对不起原作者。。。）

HTML代码：

<a onclick="tableToExcel()">点击此处下载</a>
<table id="daochuTable">
这里是要导出的table内容就不赘述了
</table>

 

js代码：

function base64(content) {
        return window.btoa(unescape(encodeURIComponent(content)));
    }
function tableToExcel() {
        var excelContent = $("#daochuTable").html();
        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 = "导出excel的名称.xlsx";
        a.href = link;
        a.click();
}

 

posted @ 2020-10-15 15:21  Raya73  阅读(335)  评论(0)    收藏  举报