table导出为excel
<!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').innerHTMLwinname.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" ><INPUT TYPE="button" VALUE="Excel 查看" ><INPUT TYPE="BUTTON" value="本页存为.." ><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>
页:
[1]