html中将table数据直接导入到excel中

小咪咪 2022-05-19 14:27 497阅读 0赞

方法一、通过<a>标签（可定义文件名称）：

导出到excel方法：

var tableToExcel2 = (function () \{  
    var uri = 'data:application/vnd.ms-excel;base64,',  
        template = '<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"><head></head><body><table>\{table\}</table></body></html>';

base64 = function (s) \{ return window.btoa(unescape(encodeURIComponent(s))) \},  
        format = function (s, c) \{ return s.replace(/\{(\\w+)\}/g, function (m, p) \{ return c\[p\]; \}) \};  
    return function (table, filename) \{  
        if (!table.nodeType) table = document.getElementById(table)  
        var ctx = \{ worksheet: name || 'Worksheet', table: table.innerHTML \}  
        document.getElementById("dlink").href = uri + base64(format(template, ctx));  
        document.getElementById("dlink").download = filename + ".xls";  
        document.getElementById("dlink").click();  
    \}  
\})();

方法二、直接使用<button>标签：

脚本：

//将table数据直接导入到excel中  
var timer;  
function excels(table, fileName) \{  
    if (getExplorer() == 'ie') \{  
        var curTbl = document.getElementById(table);  
        var oXl = new ActiveXObject("Excel.Application");//创建AX对象excel   
        var oWB = oXL.Workbooks.Add();//获取workbook对象  
        var xlsheet = oWB.Worksheets(1);//激活当前sheet  
        var sel = document.body.createTextRange();  
        sel.moveToElementText(curTbl);//把表格中的内容移到TextRange中   
        sel.select;//全选TextRange中内容  
        sel.execCommand("Copy");//复制TextRange中内容  
        xlsheet.Paste();//粘贴到活动的EXCEL中  
        oXL.Visible = true;//设置excel可见属性  
        try \{  
            var filename = oXL.Application.GetSaveAsFilename("Excel.xls", "Excel Spreadsheets (\*.xls), \*.xls");  
        \} catch (e) \{  
            window.print("Nested catch caught " + e);  
        \} finally \{  
            oWB.SaveAs(filename);  
            oWB.Close(savechanges = false);  
            oXL.Quit();  
            oXL = null;//结束excel进程，退出完成  
            timer = window.setInterval("Cleanup();", 1);  
        \}  
    \} else \{  
        tableToExcel(table, fileName);  
    \}  
\}  
function Cleanup() \{  
    window.clearInterval(timer);  
    CollectGarbage();//CollectGarbage,是IE的一个特有属性,用于释放内存的  
\}  
var tableToExcel = (function () \{  
    var uri = 'data:application/vnd.ms-excel;base64,',  
        template = '<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"><head></head><body><table>\{table\}</table></body></html>';

base64 = function (s) \{ return window.btoa(unescape(encodeURIComponent(s))) \},  
        format = function (s, c) \{  
            return s.replace(/\{(\\w+)\}/g,  
            function (m, p) \{ return c\[p\]; \})  
        \};  
    return function (table, name) \{  
        if (!table.nodeType) table = document.getElementById(table);  
        var ctx = \{ worksheet: name || 'Worksheet', table: table.innerHTML \};  
        window.location.href = uri + base64(format(template, ctx))  
    \}  
\})();

注意：IE下需要安装OFFICE excel才可以导出。

三、利用插件：

参数网址：[https://github.com/kayalshri/tableExport.jquery.plugin][https_github.com_kayalshri_tableExport.jquery.plugin]

四、参照网址：[https://github.com/Chuyue0/javascript-demo/blob/master/tableExporeExcel.html][https_github.com_Chuyue0_javascript-demo_blob_master_tableExporeExcel.html]

[https_github.com_kayalshri_tableExport.jquery.plugin]: https://github.com/kayalshri/tableExport.jquery.plugin
[https_github.com_Chuyue0_javascript-demo_blob_master_tableExporeExcel.html]: https://github.com/Chuyue0/javascript-demo/blob/master/tableExporeExcel.html