html复制到excel,HTML TABLE拷贝到剪贴板，导出到EXCEL

1 拷贝到剪贴板

function selectElementContents(el) {

var body = document.body, range, sel;

if (document.createRange && window.getSelection) {

range = document.createRange();

sel = window.getSelection();

sel.removeAllRanges();

try {

range.selectNodeContents(el);

sel.addRange(range);

} catch (e) {

range.selectNode(el);

sel.addRange(range);

}

document.execCommand("copy");

} else if (body.createTextRange) {

range = body.createTextRange();

range.moveToElementText(el);

range.select();

range.execCommand("Copy");

}

}

财季代码名称

202006002353杰瑞股份202006603613国联股份202006600745闻泰科技202006600346恒力石化202006002847盐津铺子

---

οnclick="selectElementContents( document.getElementById('tables') );">

2导出到EXCEL，IE不支持

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

if (!table.nodeType) table = document.getElementById(table)

var ctx = { worksheet: name || 'Worksheet', table: table.innerHTML }

document.getElementById("dlink").href = uri + base64(format(template, ctx));

document.getElementById("dlink").download = filename;

document.getElementById("dlink").click();

}

})()

财季代码名称

202006002353杰瑞股份202006603613国联股份202006600745闻泰科技202006600346恒力石化202006002847盐津铺子

---

3拷贝到剪贴板和导出到EXCEL二合一

var tableToExcel = (function () {

var uri = 'data:application/vnd.ms-excel;base64,',

template = '

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

财季代码名称

202006002353杰瑞股份202006603613国联股份202006600745闻泰科技202006600346恒力石化202006002847盐津铺子

---

value="Export to Excel">