HTML导出Excel的实例代码

这篇文章详解html导出excel的实例代码

装修摊销报表.td_head{ text-align:center;font-size:13pt;font-weight:800;font-family:宋体;border:0.03cm;background-color:silver;  }.td_entry{ text-align:left;font-size:10pt;font-weight:200;font-family:宋体;border:thin;  } .td_fraction{ text-align:right;font-size:10pt;font-weight:200;font-family:宋体;border:thin;mso-number-format:"0.00"; }

登录后复制序号机构名称物业类型物业名称职场名称合同编号装修类型合同金额结算金额租赁期受益期结算日摊销期(月)装修费总额
(A)累计摊销金额
(B)剩余摊销金额
(C=A-B)本月摊销额
(D)装修费总额
(财务结转后)
(E)累计摊销金额
(财务结转后)
(F)剩余摊销金额
(财务结转后)
(G=E-F)本年累计摊销金额
(H)小计德城物业德城物业德城物业LC0100231305151600080002015-6-92015-6-620150620150788888605255556255551122015 //第五种方法 var idTmr; 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'; } } function method5(tableid) { if(getExplorer()=='ie') { var curTbl = document.getElementById(tableid); var oXL = new ActiveXObject(“Excel.Application”); var oWB = oXL.Workbooks.Add(); var xlsheet = oWB.Worksheets(1); var sel = document.body.createTextRange(); sel.moveToElementText(curTbl); 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); } } else { tableToExcel(tableid) } } function Cleanup() { window.clearInterval(idTmr); CollectGarbage(); } var tableToExcel = (function() { var uri = 'data:application/vnd.ms-excel;base64,', template = '

{table}

以上就是HTML导出Excel的实例代码的详细内容，更多请关注【创想鸟】其它相关文章！

发布者：PHP中文网，转转请注明出处：https://www.chuangxiangniao.com/p/3253706.html

HTML Excel