Repeater 导出execl

Question

呵呵，自己写导出语句生成 "<table><tr><td>000</td></tr></table>"这样的string然后输出到客户端

Answer 1

通过JS在客户端直接读取，然后通过IE的SAVEAS实现导出var obj="";
obj=按要求读取的内容
......var newwin     =window.open(" ","_blank","width=1,height=1,scrollbars=no,toolbar=no");
newwin.document.write(obj);
newwin.document.execCommand("saveas",false,ExcelFileName)) ;
newwin.opener=null;
newwin.close();

Answer 2

可以先将reapter 转换成html 软后再生成excel
   //将html导出成excel
   public void OutHtmlToExcel(string html)
        {
            string FileName = "oec2003.xls";
            System.Web.HttpResponse httpResponse = this.Page.Response;            httpResponse.AppendHeader("Content-Disposition", "attachment;filename=" + HttpUtility.UrlEncode(FileName, System.Text.Encoding.UTF8));
            httpResponse.ContentEncoding =System.Text.Encoding.Default;
            httpResponse.ContentType = "application/ms-excel";
            System.IO.StringWriter tw = new System.IO.StringWriter();
            System.Web.UI.HtmlTextWriter hw = new System.Web.UI.HtmlTextWriter(tw);            string filePath = Page.Server.MapPath(".") + "\\" + FileName;            System.IO.StreamWriter sw = System.IO.File.CreateText(filePath);
            sw.Write(html);
            sw.Close();            httpResponse.Write(html);
            httpResponse.End();
        }  protected void Button3_Click(object sender, EventArgs e)
        {
            System.Text.StringBuilder strb = new System.Text.StringBuilder();
            System.IO.StringWriter sw = new System.IO.StringWriter(strb);
            System.Web.UI.HtmlTextWriter htw = new HtmlTextWriter(sw);
            //执行控件的render并输出到HtmlTextWriter里
              this.Repeater1.RenderControl(htw);
            string s = strb.ToString();            OutHtmlToExcel(s);        }