<HTML>
<HEAD>
<TITLE> New Document </TITLE>
<script type="text/javascript">
function table2xls(){ //重写String的Trim()方法
function String.prototype.Trim() {return this.replace(/(^/s*)|(/s*$)/g,"");}
try {
var e=document.getElementById("myTable");
var s="";
for(var j=0;j<e.rows.length;j++){
if(e.rows[0].cells[0].innerText.Trim()=="") {
for(var i=1;i<e.rows[j].cells.length;i++)
s+=e.rows[j].cells[i].innerText.Trim()+"/t";
}else{
for(var i=0;i<e.rows[j].cells.length;i++)
s+=e.rows[j].cells[i].innerText.Trim()+"/t";
}
s+="/r/n";
}
var myDate = new Date();
var dataStr = myDate.getFullYear() + "" + (myDate.getMonth()+1) + "" + myDate.getDate() + "" +
myDate.getHours() + "" + myDate.getMinutes() + "" + myDate.getSeconds();
document.execCommand('Saveas',true,'%homeDrive%//exportxls'+ dataStr);
}catch(e){}
}
</script>
</HEAD>
<BODY>
※IE下导出excel<br/>
※导出类型可以是:word(.doc),Excel(.xls)<br/>
※由于IE6可以修改document.execCommand('Saveas',true,'%homeDrive%//exportxls'+ dataStr+".xls");<br/>
※由于IE6以上的浏览器处于安全的考虑,保存为excel时不能加xls,如果要保存为excel,可以自己加入后缀xls<br/>
<input class="btn1" type="button" value="导出" οnclick="table2xls();">
<table width="600" border="1" cellspacing="0" cellpading="0" id="myTable">
<tr>
<td align="center" colspan="4" ><strong><font color="red">生成的考核结果</font></strong></td>
</tr>
<tr>
<td align="center" >考评对象</td>
<td align="center">考核总分</td>
<td align="center">排名</td>
</tr>
<tr>
<td align="center">aa</td>
<td align="center">98.3</td>
<td align="center">5</td>
</tr>
<tr>
<td align="center"> </td>
<td align="center"> </td>
<td align="center"> </td>
</tr>
</table>
</BODY>
</HTML>