repeater 导出excell

数据绑定到Repeater1 ，下面是将Repeater1的内容导出的示例代码

            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》

 

posted @ 2010-08-13 15:11  任飞儿  阅读(248)  评论(0)  编辑  收藏  举报