数据绑定到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 on 2005-08-27 11:08  powerlc  阅读(4268)  评论(6编辑  收藏  举报