html页面表格转Excel

最新推荐文章于 2025-07-04 11:51:31 发布

原创最新推荐文章于 2025-07-04 11:51:31 发布 · 3.4k 阅读

5 ·

CC 4.0 BY-SA版权

本文介绍了一种兼容IE及现代浏览器的HTML表格导出为Excel的方法，通过JavaScript实现，针对不同浏览器采用不同的导出策略。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

//tableid:表格id 创建一个a标签，id为download
//jQuery HTML导出Excel文件(兼容IE及所有浏览器)    
    function HtmlExportToExcel(tableid) {
        var filename = "下载的Excel名称";
        if (getExplorer() == 'ie' || getExplorer() == undefined) {
            HtmlExportToExcelForIE(tableid, filename);
        }
        else {
            HtmlExportToExcelForEntire(tableid, filename)
        }
    }
    //IE浏览器导出Excel
    function HtmlExportToExcelForIE(tableid, filename) {
        try {
            var winname = window.open('', '_blank', 'top=10000');
            var strHTML = document.getElementById(tableid).innerHTML;

            winname.document.open('application/vnd.ms-excel', 'export excel');
            winname.document.writeln(strHTML);
            winname.document.execCommand('saveas', '', filename + '.xls');
            winname.close();

        } catch (e) {
            alert(e.description);
        }
    }
    //非IE浏览器导出Excel
    var HtmlExportToExcelForEntire = (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><!--[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><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 }
            document.getElementById("download").href = uri + base64(format(template, ctx));
            document.getElementById("download").download = name + ".xls";
            document.getElementById("download").click();
        }
    })()
    function getExplorer() {
        var explorer = window.navigator.userAgent;
        //ie
        if (explorer.indexOf("MSIE") >= 0) {
            return 'ie';
        }
        //firefox
        else if (explorer.indexOf("Firefox") >= 0) {
            return 'Firefox';
        }
        //Chrome
        else if (explorer.indexOf("Chrome") >= 0) {
            return 'Chrome';
        }
        //Opera
        else if (explorer.indexOf("Opera") >= 0) {
            return 'Opera';
        }
        //Safari
        else if (explorer.indexOf("Safari") >= 0) {
            return 'Safari';
        }
    }