导出excel打印 private void ImageButton1_Click( object sender, System.Web.UI.ImageClickEventArgs e) { Response.Clear(); Response.Buffer= true; Response.AppendHeader("Content-Disposition","attachment;filename=Borrow.xls"); Response.ContentEncoding=System.Text.Encoding.GetEncoding("gb2312"); Response.ContentType = "application/ms-excel"; this.EnableViewState = false; System.Globalization.CultureInfo myCItrad = new System.Globalization.CultureInfo("ZH-CN",true); System.IO.StringWriter oStringWriter = new System.IO.StringWriter(myCItrad); System.Web.UI.HtmlTextWriter oHtmlTextWriter = new System.Web.UI.HtmlTextWriter(oStringWriter); Table3.RenderControl(oHtmlTextWriter); Response.Charset="gb2312"; Response.Write(oStringWriter.ToString()); Response.End(); } 红色为导出文件名和要导出页面中的table 首先在网页中添加: < OBJECT id ="WebBrowser" height ="0" width ="0" classid ="CLSID:8856F961-340A-11D0-A96B-00C04FD705A2" VIEWASTEXT > </ OBJECT > 然后就可以依次加入功能按钮了: < input onclick ="document.all.WebBrowser.ExecWB(6,1)" type ="button" value ="打印" > < input onclick ="document.all.WebBrowser.ExecWB(6,6)" type ="button" value ="直接打印" > < input onclick ="document.all.WebBrowser.ExecWB(8,1)" type ="button" value ="页面设置" > < input onclick ="document.all.WebBrowser.ExecWB(7,1)" type ="button" value ="打印预览" > < INPUT type ="button" value ="关闭窗口" onclick ="javascript:window.close()" > 将这两块东西放到 < center class =noprint ></ center > 就不会打印这些按钮了。当然要定义noprint了: < style media ="print" > .Noprint {}{ DISPLAY: none }</style>只要把不想打印的东西的css设置成noprint就可以了。 现在就实现了基本的web打印,需要注意的情况如下: 必须将ie的internet选项的安全设置中对于没有标记为安全的ActiveX控件进行设置成提示或者启用,否则会报错,导致不可用。 如果在vs.net编辑环境下编辑该页面,它经常自动的给object添加多余的参数,有了这些东西,打印就会出错,所以要记得最后保存的时候删除它们。 为了简便并且达到最好的效果,我们可以在一个页面实现编辑和打印,这时候会需要很多的textbox,我们把它的css设置成.edittext { overflow-y:visible; width: 100%; border-top: none; border-right: none; border-bottom: none; border-left: none; }就可以实现在打印的时候不显示边框和multiline的textbox不显示滚动条了。 还有一些小经验就是在设置标格宽度的时候,对于A4纸张,横打用920,竖打用640,效果最好。 1、控制"纵打"、 横打”和“页面的边距。 (1) < script defer > function SetPrintSettings() { // -- advanced features factory.printing.SetMarginMeasure(2) // measure margins in inches factory.SetPageRange(false, 1, 3) // need pages from 1 to 3 factory.printing.printer = "HP DeskJet 870C" factory.printing.copies = 2 factory.printing.collate = true factory.printing.paperSize = "A4" factory.printing.paperSource = "Manual feed" // -- basic features factory.printing.header = "This is MeadCo" factory.printing.footer = "Advanced Printing by scriptX" factory.printing.portrait = false factory.printing.leftMargin = 1.0 factory.printing.topMargin = 1.0 factory.printing.rightMargin = 1.0 factory.printing.bottomMargin = 1.0 } </ script > (2) < script language ="javascript" > function printsetup(){ // 打印页面设置 wb.execwb(8,1); } function printpreview(){ // 打印页面预览 wb.execwb(7,1); } function printit() { if (confirm(''确定打印吗?'')) { wb.execwb(6,6) } } </ script > </ head > < body > < OBJECT classid ="CLSID:8856F961-340A-11D0-A96B-00C04FD705A2" height =0 id =wb name =wb width =0 ></ OBJECT > < input type =button name =button_print value ="打印" onclick ="javascript:printit()" > < input type =button name=button_setup value ="打印页面设置" onclick ="javascript:printsetup();" > < input type =button name=button_show value ="打印预览" onclick ="javascript:printpreview();" > < input type =button name =button_fh value ="关闭" onclick ="javascript:window.close();" > ------------------------------------------------ 关于这个组件还有其他的用法,列举如下: WebBrowser.ExecWB(1,1) 打开 Web.ExecWB(2,1) 关闭现在所有的IE窗口,并打开一个新窗口 Web.ExecWB(4,1) 保存网页 Web.ExecWB(6,1) 打印 Web.ExecWB(7,1) 打印预览 Web.ExecWB(8,1) 打印页面设置 Web.ExecWB(10,1) 查看页面属性 Web.ExecWB(15,1) 好像是撤销,有待确认 Web.ExecWB(17,1) 全选 Web.ExecWB(22,1) 刷新 Web.ExecWB(45,1) 关闭窗体无提示 2、分页打印 < HTML > < HEAD > < STYLE > P {}{page-break-after: always} </ STYLE > </ HEAD > < BODY > <% while not rs.eof %> < P > <% = rs( 0 ) %> </ P > <% rs.movenext %> <% wend %> </ BODY > </ HTML > 3、ASP页面打印时如何去掉页面底部的路径和顶端的页码编号 (1)ie的文件-〉页面设置-〉讲里面的页眉和页脚里面的东西都去掉,打印就不出来了。 (2) < HTML > < HEAD > < TITLE > New Document </ TITLE > < META NAME ="Generator" CONTENT ="EditPlus" > < META NAME ="Author" CONTENT ="YC" > < script language ="VBscript" > dim hkey_root,hkey_path,hkey_key hkey_root="HKEY_CURRENT_USER" hkey_path="/Software/Microsoft/Internet Explorer/PageSetup" ''//设置网页打印的页眉页脚为空 function pagesetup_null() on error resume next Set RegWsh = CreateObject("Wscript.Shell") hkey_key="/header" RegWsh.RegWrite hkey_root+hkey_path+hkey_key,"" hkey_key="/footer" RegWsh.RegWrite hkey_root+hkey_path+hkey_key,"" end function ''//设置网页打印的页眉页脚为默认值 function pagesetup_default() on error resume next Set RegWsh = CreateObject("Wscript.Shell") hkey_key="/header" RegWsh.RegWrite hkey_root+hkey_path+hkey_key,"&w&b页码,&p/&P" hkey_key="/footer" RegWsh.RegWrite hkey_root+hkey_path+hkey_key,"&u&b&d" end function </ script > </ HEAD > < BODY > < br /> < br /> < br /> < br /> < br /> < br />< p align =center > < input type ="button" value ="清空页码" onclick =pagesetup_null() > < input type ="button" value ="恢复页吗" onclick =pagesetup_default() >< br /> </ p > </ BODY > </ HTML > 4、浮动帧打印 < script LANGUAGE =javascript > function button1_onclick() { var odoc=window.iframe1.document; var r=odoc.body.createTextRange(); var stxt=r.htmlText; alert(stxt) var pwin=window.open("","print"); pwin.document.write(stxt); pwin.print(); } </ script > 4、用FileSystem组件实现WEB应用中的本地特定打印 < script Language =VBscript > function print_onclick //打印函数 dim label label=document.printinfo.label.value //获得HTML页面的数据 set objfs=CreateObject("scripting.FileSystemObject") //创建FileSystem组件对象的实例 set objprinter=objfs.CreateTextFile ("LPT1:",true) //建立与打印机的连接 objprinter.Writeline("__________________________________") //输出打印的内容 objprinter.Writeline("| |") objprinter.Writeline("| 您打印的数据是:"&label& " |”) objprinter.Writeline("| |") objprinter.Writeline("|_________________________________|") objprinter.close //断开与打印机的连接 set objprinter=nothing set objfs=nothing // 关闭FileSystem组件对象 end function </script> 服务器端脚本: <%……… set conn=server.CreateObject ("adodb.connection") conn.Open "DSN=name;UID=XXXX;PWD=XXXX;" set rs=server.CreateObject("adodb.recordset") rs.Open(“select ……”),conn,1,1 ……….%> //与数据库进行交互 HTML页面编码: <HTML> ……… <FORM ID=printinfo NAME="printinfo" > <INPUT type="button" value="打印>>" id=print name=print > //调用打印函数 <INPUT type=hidden id=text1 name=label value=<%=………%>> //保存服务器端传来的数据 ……… </HTML>