点击导出table表格

<!DOCTYPE html>

<html>

<head>

<meta charset="UTF-8">

<title></title>

</head>

<body>

<div class="tools">

<button type="button" class="btn green" id="excell" onclick="method5('dataTable')" style="margin-top: 100px;margin-left: 100px;height: 30px; width: 100px">点击下载</button>

</div>

<table border="1" id="dataTable" style="margin-top: 30px;margin-left: 100px">

<tr>

<td>王婷</td>

<td>一见倾城</td>

</tr>

<tr>

<td>祈澈姑娘222</td>

<td>开发者交流平台</td>

</tr>

<tr>

<td>wwwangt</td>

<td>13661725475</td>

</tr>

</table>

</body>

<script>

//打印表格

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 border="1">{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))

}

})()

</script>

</html>
巴特西

点击导出table表格

最新文章

热门文章
