html页面导出,HTML页面导出execl表格

点击导出按钮时触发method5(“传入表格ID”)

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

'xmlns="http://www.w3.org/TR/REC-html40">

'+

'

'.excelTable  {'+

'border-collapse:collapse;'+

' border:thin solid #999; '+

'}'+

'   .excelTable  th {'+

'   border: thin solid #999;'+

'  padding:20px;'+

'  text-align: center;'+

'  border-top: thin solid #999;'+

' '+

' }'+

' .excelTable  td{'+

' border:thin solid #999;'+

'  padding:2px 5px;'+

'  text-align: center;'+

' }'+

'

',

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

//console.log(table)

if(!table.nodeType)

table = document.getElementById(table);

var ctx = {

worksheet: name || 'Worksheet',

table: table.innerHTML

}

var link = document.createElement("a");

link.href = uri+base64(format(template, ctx));

link.download = "采购结果情况汇总表.xls";//当前下载的excel名称

document.body.appendChild(link);

link.click();

document.body.removeChild(link);

}

})();

标签：execl,function,return,HTML,link,var,table,document,页面

来源： https://www.cnblogs.com/lt3232696/p/10916733.html