<button type="button" onclick="method5('tableid')">导出excel方法五</button>//按钮 <table id='tableid'>//tableid <tr> <td>1111</td> <td>2222</td> <td>3333</td> <td>4444</td> </tr> <tr> <td>aaaa</td> <td>bbbb</td> <td>cccc</td> <td>dddd</td> </tr> </table> 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 = '<html><head><meta charset="utf-8"></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)) } })()
相关推荐:
js创建一个map代码分享
js创建html浏览器导出下载的方法
d3.js创建物流地图
以上就是用js创建excel文档的详细内容。
