html中将table数据直接导入到excel中

方法一、通过标签（可定义文件名称）：

导出到excel方法：

var tabletoexcel2 = (function () {
var uri = 'data:application/vnd.ms-excel;base64,',
template = '

{c}{table} ';

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, 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 + ".xls";
document.getelementbyid("dlink").click();
}
})();

方法二、直接使用标签：

脚本：

function getexplorer() {//获取
var explorer = window.navigator.useragent;
if (explorer.indexof("msie") >= 0 || (explorer.indexof("windows nt 6.1;") >= 0 && explorer.indexof("trident/7.0;") >= 0)) {
return 'ie';
} else if (explorer.indexof("firefox") >= 0) {
return 'firefox';
} else if (explorer.indexof("chrome") >= 0) {
return 'chrome';
} else if (explorer.indexof("opera") >= 0) {
return 'opera';
} else if (explorer.indexof("safari") >= 0) {
return 'safari';
}
}

//将table数据直接导入到excel中
var timer;
function excels(table, filename) {
if (getexplorer() == 'ie') {
var curtbl = document.getelementbyid(table);
var oxl = new activexobject("excel.application");//创建ax对象excel
var owb = oxl.workbooks.add();//获取workbook对象
var xlsheet = owb.worksheets(1);//激活当前sheet
var sel = document.body.createtextrange();
sel.movetoelementtext(curtbl);//把表格中的内容移到textrange中
sel.select;//全选textrange中内容
sel.execcommand("copy");//复制textrange中内容
xlsheet.paste();//粘贴到活动的excel中
oxl.visible = true;//设置excel可见属性
try {
var filename = oxl.application.getsaveasfilename("excel.xls", "excel spreadsheets (*.xls), *.xls");
} catch (e) {
window.print("nested catch caught " + e);
} finally {
owb.saveas(filename);
owb.close(savechanges = false);
oxl.quit();
oxl = null;//结束excel进程，退出完成
timer = window.setinterval("cleanup();", 1);
}
} else {
tabletoexcel(table, filename);
}
}
function cleanup() {
window.clearinterval(timer);
collectgarbage();//collectgarbage,是ie的一个特有属性,用于释放内存的
}
var tabletoexcel = (function () {
var uri = 'data:application/vnd.ms-excel;base64,',
template = '

{c}{table} ';

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))
}
})();

注意：ie下需要安装office excel才可以导出。

三、利用插件：

参数网址：https://github.com/kayalshri/tableexport.jquery.plugin

四、参照网址：https://github.com/chuyue0/javascript-demo/blob/master/tableexporeexcel.html