SQL 查询数据打印并导出EXECL

 导出提交的页面加上:
response.contenttype= "application/msexcel "
response.addheader   "content-disposition ", "attachment;filename=export.xls "
打印: <span   id=bt1> <input   type= "submit "   name= "Submit "   value= "打印 "onClick= "javascript:bt1.innerHTML= ' ';window.print();return   false; "   style= "cursor:hand "> </span>

 

 

<%
if   request( "action ")= "down "   then
response.ContentType   = "application/vnd.ms-excel "
Response.AddHeader   "Content-Disposition ",   "attachment;   filename=1.xls "
end   if
%>
<a   href= "?action=down "> 保存成excel </a>

 

 

打印预览框架里的内容

<OBJECT classid="CLSID:8856F961-340A-11D0-A96B-00C04FD705A2" height="0" id="WebBrowser" width="0"></OBJECT>
<input name="Button" onClick="document.all.hiddenframe.ExecWB(7,1);" type="button" value="打印预览">
<iframe frameborder="0" height="10%" width