C#打印EXCEL(三)

来源：互联网发布：淘宝卖家怎么导出订单编辑：程序博客网时间：2024/05/22 06:51

0.要打印的页面JS方法调用

 //导出        function RePort() {            var xmmc = document.getElementById("txtXMMC").value;            var sec = document.getElementById("txtsec").value;            var tzsmll = document.getElementById("txttzsmll").value;            var tzmax = document.getElementById("txttzmax").value;            var mjsmll = document.getElementById("txtmjsamll").value;            var mjmax = document.getElementById("txtmjmax").value;            var xmlx = $("#ddlxmlx").val();            var xmjd = $("#ddlxmjd").val();            $.ligerDialog.open({ title: '请稍后...', width: 200, content: '正在导出，请稍后.....'            , url: "../RePort.aspx?xmmc=" + encodeURI(encodeURI(xmmc)) + "&sec=" + sec + "&tzsmll=" + tzsmll + "&tzmax=" + tzmax + "&mjsmll=" + mjsmll + "&mjmax=" + mjmax + "&xmlx=" + xmlx + "&xmjd=" + xmjd + ""            });            setTimeout(function () {                $.ligerDialog.hide();            }, 3000);        }

1.RePort.aspx页面前台方法实用用户控件

 <div style="width: 100%;">        <uc1:Pub ID="SearchRePort" runat="server" />    </div>

2.后台方法1.

 private string RedContro()        {            string result = "";            StringBuilder build = new StringBuilder();            HtmlTextWriter htmlWriter = new HtmlTextWriter(new StringWriter(build));            try            {                this.SearchRePort.RenderControl(htmlWriter);            }            catch { }            finally            {                htmlWriter.Flush();                result = build.ToString();            }            return result;//返回控件的HTML代码         }

3.后台方法2

 /// <summary>        /// 导出Excel        /// </summary>        void exportexcel()        {            Response.Clear();            Response.Buffer = true;            Response.Charset = "utf-8";            Response.AppendHeader("Content-Disposition", "attachment;filename=" + HttpUtility.UrlEncode(expTitle + ".xls", Encoding.UTF8).ToString());            Response.ContentEncoding = System.Text.Encoding.GetEncoding("utf-8");            Response.ContentType = "application/ms-excel";            this.EnableViewState = false;            System.IO.StringWriter oStringWriter = new System.IO.StringWriter();            System.Web.UI.HtmlTextWriter oHtmlTextWriter = new System.Web.UI.HtmlTextWriter(oStringWriter);            oHtmlTextWriter.WriteLine(RedContro());            Response.Write(oStringWriter.ToString());            Response.End();        }

4.调用即可

exportexcel();

参考资源：http://download.csdn.net/detail/hugaozhuang/7338367

0 0