html导出excel代码,html页面导出为excel表格(示例代码)

简介这篇文章主要介绍了html页面导出为excel表格(示例代码)以及相关的经验技巧，文章约4421字，浏览量324，点赞数9，值得推荐！

导出考勤表格

王婷111	一见倾城333
祈澈姑娘222	Python开发者交流平台44
wwwangting888	13661725475

//打印表格

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 = ‘

‘,

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))

}

})()