<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312" />
<title>EB页面导出为EXCEL文档的方法 </title>
<script type="text/javascript" >
function saveCode(tableid) {
var winname = window.open('', 'newwin', '');
var strHTML = document.getElementById(tableid).innerHTML;//根据表格的id获取内容
winname.document.open('text/html', 'replace');
winname.document.writeln(strHTML);
winname.document.execCommand('saveas','','*.xls'); //保存
winname.close();
}
function myprint(tableid){
var winname = window.open('', 'newwin', '');
var strHTML = document.getElementById(tableid).innerHTML;
winname.document.open('text/html', 'replace');
winname.document.writeln(strHTML);
winname.document.execCommand('print'); //打印
winname.close();
}
</script>
</head>
<body>
<div id="tableExcel">
<table id="test" width="100%" border="1" cellspacing="0" cellpadding="0">
<tr>
<td colspan="5" align="center"><font size="6"><b>WEB页面导出为EXCEL文档的方法</b> </font></td>
</tr>
<tr>
<td>列标题1 </td>
<td>列标题2 </td>
<td>列标题3 </td>
<td>列标题4 </td>
<td>列标题5 </td>
</tr>
<tr>
<td>aaa </td>
<td>bbb </td>
<td>ccc </td>
<td>ddd </td>
<td>eee </td>
</tr>
<tr>
<td>AAA </td>
<td>BBB </td>
<td>CCC </td>
<td>DDD </td>
<td>EEE </td>
</tr>
<tr>
<td>FFF </td>
<td>GGG </td>
<td>HHH </td>
<td>III </td>
<td>JJJ </td>
</tr>
<tr>
<td>aaa </td>
<td>bbb </td>
<td>ccc </td>
<td>ddd </td>
<td>eee </td>
</tr>
<tr>
<td>AAA </td>
<td>BBB </td>
<td>CCC </td>
<td>DDD </td>
<td>EEE </td>
</tr>
<tr>
<td colspan="5">FFFGGGHHHIIIJJJ </td>
</tr>
<tr>
<td>aaa </td>
<td>bbb </td>
<td>ccc </td>
<td>ddd </td>
<td>eee </td>
</tr>
<tr>
<td>AAA </td>
<td>BBB </td>
<td>DDD </td>
<td>EEE </td>
</tr>
<tr>
<td>FFF </td>
<td>GGG </td>
<td>III </td>
<td>JJJ </td>
</tr>
</table>
</div>
<input type="button" value="另存为 Excel" οnclick="saveCode('tableExcel')">
<input type="button" value="打印表格" οnclick="myprint('tableExcel')"/>
</body>
</html>
实现将网页中的表格保存为EXCEL表格功能,及将网页中的表格打印功能。
window.open('', 'newwin', ''); //打开窗口
var strHTML = document.getElementById(tableid).innerHTML;//根据表格的id获取内容
winname.document.open('text/html', 'replace'); //打开新的document
winname.document.writeln(strHTML); //将表格内容写入
winname.document.execCommand('saveas','','*.xls'); //保存
winname.document.execCommand('print'); //打印