怎么把多个GridView和Repeater导入到word或者excel中

最近开发网上商城有发现我们会涉及到订单打印的问题,本来想到直接显示打印即可但是考虑还得下载到本地,最后只有直接选择控件按流方式输出。

导入到word中代码如下:

        protected void Button1_Click(object sender, EventArgs e)
        {
            StringBuilder sb = new StringBuilder();
            StringWriter sw = new StringWriter(sb);
            HtmlTextWriter htw = new HtmlTextWriter(sw);
            Page page = new Page();
            HtmlForm form = new HtmlForm();
            GridView1.EnableViewState = false;
            rptMlist.EnableViewState = false;
            myGridView.EnableViewState = false;
            page.EnableEventValidation = false;
            page.EnableViewState = false;
            // Realiza las inicializaciones de la instancia de la clase Page que requieran los diseñadores RAD.
            page.DesignerInitialize();
            page.Controls.Add(form);
            form.Controls.Add(GridView1);
            form.Controls.Add(rptMlist);
            form.Controls.Add(myGridView);
            page.RenderControl(htw);
            Response.Clear();
            Response.Buffer = true;
            Response.ContentType = "application/vnd.ms-word"; 
            Response.AddHeader("Content-Disposition", "attachment;filename=" + PID + ".doc");
            Response.Charset = "UTF-8";
            Response.ContentEncoding = Encoding.Default;
            Response.Write(sb.ToString());
            Response.End();
        }

代码很简单,如果大家有更好的方法可以探讨一下。

 

posted @ 2014-10-21 15:13  Angelasp  阅读(390)  评论(0编辑  收藏  举报