Repeater导出excel

徒步-天下 2009-09-14 09:46:59

Repeater导出excel,我导出的都是html代码，望大家帮忙谢谢！



 private void repeaterToExecl(Repeater r)

        {

            Response.Clear();

            Response.AddHeader("Content-Disposition", "inline;filename=test.xls");



            Response.Charset = "GB2312";

            Response.ContentEncoding = Encoding.UTF8;



            Response.ContentType = "application/vnd.xls";

            System.IO.StringWriter stringWrite = new System.IO.StringWriter();

            System.Web.UI.HtmlTextWriter htmlWrite = new HtmlTextWriter(stringWrite);



            Page.EnableViewState = false;



            r.RenderControl(htmlWrite);

            Response.Write(stringWrite.ToString());

            Response.End(); 





        }

...全文

487 9 打赏收藏转发到动态举报

写回复

用AI写文章

9 条回复

切换为时间正序

请发表友善的回复…

发表回复

tongzhetianlai 2012-04-13

打赏
举报

很有用，真的！那个，感谢啊！！！

徒步-天下 2009-09-14

打赏
举报

谢谢各位一切ok，原因：Repeater里面我没有把table写全，
没有重复的地方我写在了外面。

feixian49 2009-09-14

打赏
举报

指间、魔法师 2009-09-14

打赏
举报



 System.IO.StringWriter sw = new System.IO.StringWriter();

            System.Web.UI.HtmlTextWriter hw = new System.Web.UI.HtmlTextWriter(sw);

            this.Repeater1.RenderControl(hw);



            Response.Clear();

            Response.ContentType = "application/vnd.ms-excel";

            Response.Charset = "";

            Page.EnableViewState = false;



            Response.AppendHeader("Content-Disposition", "attachment;filename=Teacher.xls");

            Response.Write("<html><head><meta http-equiv=Content-Type content=\"text/html; charset=GB2312\"><title>                                Copyright by SDU</title></head><body><center>");

            Response.Write(sw.ToString());

            Response.Write("</center></body></html>");

            Response.End();

            //当字符型的数字串导出到excel的时候，经常自动变为科学记数法表示，解决的方法，绑定到Repeater1的时候如此：

            //<td style="vnd.ms-excel.numberformat:@"><%# DataBinder.Eval(Container.DataItem, "shenfenzheng") %></td>

legu1 2009-09-14

打赏
举报

顶一楼

limii 2009-09-14

打赏
举报

shankaipingo 2009-09-14

打赏
举报

顶1楼

silentwins 2009-09-14

打赏
举报

要不将数据源导出到Excel，要不用excel组件自定义导出……

dongjianhua520520 2009-09-14

打赏
举报

rpt.DataSourse=??;
rpt.DataBind();
Response.Charset = "GB2312";
Response.ContentEncoding = System.Text.Encoding.UTF7;
string FileName = "111.xls";
Response.AppendHeader("Content-Disposition", "attachment;filename=" + HttpUtility.UrlEncode(FileName, Encoding.UTF8).ToString());
Response.ContentType = "application/ms-excel";
this.EnableViewState = false;
StringWriter tw = new StringWriter();
HtmlTextWriter hw = new HtmlTextWriter(tw);
rpt.RenderControl(hw);
Response.Write(tw.ToString());
Response.End();