JS 浏览器将table内容以excel形式保存到本地

最新推荐文章于 2024-06-12 13:28:59 发布

HandesomeLi

最新推荐文章于 2024-06-12 13:28:59 发布

阅读量1k

点赞数

分类专栏：浏览器兼容文章标签： excel Js table 兼容浏览器

本文链接：https://blog.csdn.net/lishuai1127/article/details/80064790

版权

浏览器兼容专栏收录该内容

2 篇文章 0 订阅

订阅专栏

这是适配ie浏览器下的数据以excel形式保存下来；使用字符串拼接 table，不是建立节点，满足ie

                $("body").append(excel);
                var tableExcel = document.getElementById("tableE");
                var oXL = new ActiveXObject("Excel.Application");
                var oWB = oXL.Workbooks.Add();
                var xlsheet = oWB.Worksheets(1);
                var sel = document.body.createTextRange();
                sel.moveToElementText(tableExcel);
                sel.select;
                sel.execCommand("Copy");
                xlsheet.Paste();
                oXL.Visible = true;
                try {
                    var fname = oXL.Application.GetSaveAsFilename("Excel.xls", "Excel Spreadsheets (*.xls), *.xls");
                } catch (e) {
                    print("Nested catch caught " + e);
                } finally {
                    oWB.SaveAs(fname);
                    oWB.Close(savechanges = false);
                    oXL.Quit();
                    oXL = null;
                    idTmr = window.setInterval("Cleanup();", 1);
                }

火狐和谷歌的形式如下：

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 += '<meta http-equiv="content-type" content="application/vnd.ms-excel; charset=UTF-8">';
excelFile += '<meta http-equiv="content-type" content="application/vnd.ms-excel';
excelFile += '; charset=UTF-8">';
excelFile += "<head>";
excelFile += "<!--[if gte mso 9]>";
excelFile += "<xml>";
excelFile += "<x:ExcelWorkbook>";
excelFile += "<x:ExcelWorksheets>";
excelFile += "<x:ExcelWorksheet>";
excelFile += "<x:Name>";
excelFile += "{worksheet}";
excelFile += "</x:Name>";
excelFile += "<x:WorksheetOptions>";
excelFile += "<x:DisplayGridlines/>";
excelFile += "</x:WorksheetOptions>";
excelFile += "</x:ExcelWorksheet>";
excelFile += "</x:ExcelWorksheets>";
excelFile += "</x:ExcelWorkbook>";
excelFile += "</xml>";
excelFile += "<![endif]-->";
excelFile += "</head>";
excelFile += "<body>";
excelFile += excel;
excelFile += "</body>";
excelFile += "</html>";

               var uri = 'data:application/vnd.ms-excel;charset=utf-8,' + encodeURIComponent(excelFile);
                var link = document.createElement("a");
                link.href = uri;
                link.style = "visibility:hidden";
                link.download = FileName + ".xls";
                document.body.appendChild(link);
                link.click();
                document.body.removeChild(link);

HandesomeLi

关注

0
点赞
踩
0

收藏

觉得还不错? 一键收藏
0
评论
JS 浏览器将table内容以excel形式保存到本地

这是适配ie浏览器下的数据以excel形式保存下来；使用字符串拼接 table，不是建立节点，满足ie $("body").append(excel); var tableExcel = document.getElementById("tableE"); var oXL = new Act...
复制链接

扫一扫

专栏目录