table导出为excel -优快云博客

本文链接：https://blog.youkuaiyun.com/iteye_9926/article/details/81887504

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML>
<title>导出为excel 之我的方法</title>
<style type="text/css" rel="stylesheet">
TABLE {border-top:#CCCCCC 1px solid; border-left:#CCCCCC 1px solid; font-size:12px;}
br {mso-data-placement:same-cell;}
td {border-bottom:#CCCCCC 1px solid; border-right:#CCCCCC 1px solid; text-align:left;}
body{
margin:0px;
font-size:12px;
SCROLLBAR-FACE-COLOR: #f6f6f6; 
SCROLLBAR-HIGHLIGHT-COLOR: #ffffff; 
SCROLLBAR-SHADOW-COLOR: #cccccc; 
SCROLLBAR-3DLIGHT-COLOR: #cccccc; 
SCROLLBAR-ARROW-COLOR: #330000; 
SCROLLBAR-TRACK-COLOR: #f6f6f6; 
SCROLLBAR-DARKSHADOW-COLOR: #ffffff; 
}

a {
color:blue;
text-decoration:none;
}
a:hover{
color:black;
text-decoration:underline;
}
input{
border:blue solid 1px;
}
#titletr {
    Z-Index:102;   
    position:relative;   
    Top:expression(this.offsetParent.scrollTop);
left:-1px;
background:#CCFF99;
}
</style>
</head>
<SCRIPT LANGUAGE="JavaScript">
<!--
function doSave(obj) {
//alert(document.getElementById('theexecel').innerHTML);
var winname = window.open('', 'excel1', 'top=0');
winname.document.open('text/html', 'replace');
execelcontent=document.getElementById('theexecel').innerHTML
winname.document.writeln(execelcontent);
winname.document.execCommand('saveas','','导出的excel.xls');
winname.close();
}
//-->
</SCRIPT>
<SCRIPT LANGUAGE="javascript"> 
function AllAreaExcel() 
{ 
var oXL = new ActiveXObject("Excel.Application"); 
var oWB = oXL.Workbooks.Add(); 
var oSheet = oWB.ActiveSheet; 
var sel=document.body.createTextRange(); 
sel.moveToElementText(excel2); 
//sel.select(); 
sel.execCommand("Copy"); 
oSheet.Paste(); 
oXL.Visible = true; 
} 

</SCRIPT>
<iframe id="excel1" name="excel1" width="0" height="0"></iframe>

<INPUT TYPE="button" VALUE="保存到EXCEL" ONCLICK="doSave('theexecel')">
<INPUT TYPE="button" VALUE="Excel 查看" ONCLICK="AllAreaExcel()">
<INPUT TYPE="BUTTON" value="本页存为.." οnclick="javascript:document.all.save.ExecWB(4,1)">

<OBJECT CLASSID=CLSID:8856F961-340A-11D0-A96B-00C04FD705A2 ID="save" HEIGHT=0 WIDTH=0>
</OBJECT>

<div id="theexecel" name="theexecel" style="height:100%;">
<table cellpadding="0" cellspacing="0" align="center" id="excel2" name="excel2" width='990'>
<TR>
<TD>q</TD>
<TD>w</TD>
<TD>w</TD>
<TD>w</TD>
</TR>
<TR>
<TD>w</TD>
<TD>w</TD>
<TD>w</TD>
<TD>w</TD>
</TR>
<TR>
<TD>w</TD>
<TD>w</TD>
<TD>w</TD>
<TD>w</TD>
</TR>
<TR>
<TD>e</TD>
<TD>e</TD>
<TD>e</TD>
<TD>e</TD>
</TR>
</TABLE>
</div>
</body>
</html>