一、table表格导出
<!DOCTYPE html>
<html>
<head lang="en">
<meta charset="UTF-8">
<title>表格导出</title>
<script language="JavaScript" type="text/javascript">
var idTmr;
function getExplorer() {
var explorer = window.navigator.userAgent ;
if (explorer.indexOf("MSIE") >= 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';
}
}
function method1(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 filename="统计报告"
var uri = 'data:application/vnd.ms-excel;base64,',
template = '<html xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:x="urn:schemas-microsoft-com:office:excel" xmlns="http://www.w3.org/TR/REC-html40"><head><meta charset="UTF-8"><!--[if gte mso 9]><xml><x:ExcelWorkbook><x:ExcelWorksheets><x:ExcelWorksheet><x:Name>${worksheet}</x:Name><x:WorksheetOptions><x:DisplayGridlines/></x:WorksheetOptions></x:ExcelWorksheet></x:ExcelWorksheets></x:ExcelWorkbook></xml><![endif]--></head><body><table>{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}
var a = document.createElement("a");
a.download = filename;
a.href = uri + base64(format(template, ctx));
document.body.appendChild(a);
a.click();
document.body.removeChild(a);
}
})();
</script>
</head>
<body>
<div >
<button onclick="javascript:method1('tableExcel')">导出EXCEL</button>
</div>
<div id="myDiv">
<table id="tableExcel" width="100%" border="1" cellspacing="0" cellpadding="0">
<tr>
<td colspan="5" align="center">表格导出Excel</td>
</tr>
<tr>
<td>列标题</td>
<td>列标题</td>
<td>列标题</td>
<td>列标题</td>
<td>列标题</td>
</tr>
<tr>
<td>1</td>
<td>1</td>
<td>1</td>
<td>1</td>
<td>1</td>
</tr>
<tr>
<td rowspan="2">1</td>
<td>1</td>
<td>1</td>
<td colspan="2">1</td>
</tr>
<tr>
<td>1</td>
<td>1</td>
<td>1</td>
<td>1</td>
</tr>
</table>
</div>
</body>
</html>
二 设置表格样式
template变量添加样式
template=
' <style type="text/css">' +
'table td,table th {' +
' text-align: center;' +
' }' +
'</style>' +
'</head><body><table>{table}</table></body></html>'