谁有asp.net Repeater 查询出来的数据导出Excel的代码呀

谁有asp.net Repeater 查询出来的数据导出Excel的代码呀，困扰好个几个星期了，谁有可用的代码帮帮小弟把。还有就是Excel导入到MS sql数据库。

解决方案 »

  1.   

     public void OutToExcel(GridView dg, HttpResponse httpResponse, Page httpPage)
        {        httpResponse.Clear();
            httpResponse.Buffer = true;
            httpResponse.Charset = "utf-8";
            httpResponse.AppendHeader("Content-Disposition", "attachment;filename=sap.xls");
            httpResponse.ContentEncoding = System.Text.Decoder.ReferenceEquals("utf-8"); //设置输出流为简体中文
            httpResponse.ContentType = "application/ms-excel"; //设置输出文件类型为excel文件。 
            httpPage.EnableViewState = false;
            System.Globalization.CultureInfo myCItrad = new System.Globalization.CultureInfo("ZH-CN", true);
            System.IO.StringWriter oStringWriter = new System.IO.StringWriter(myCItrad);
            System.Web.UI.HtmlTextWriter oHtmlTextWriter = new System.Web.UI.HtmlTextWriter(oStringWriter);
            dg.RenderControl(oHtmlTextWriter);
            httpResponse.Write(oStringWriter.ToString());
            httpResponse.End();
        }
      

  2.   

    参考
    http://blog.163.com/sjzlgt@126/blog/static/2688758220087794312283/
      

  3.   

    楼上两位的方法都可以用，但都不是我想要的，我的意思是，我现在想直接把前台Repeter提取到的数据以现在的个数提取出来excel。
      

  4.   

    谁出来帮忙呀。就是想实现把前台Reperter提取的数据，以现在的格式提取到excel中
      

  5.   

    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(); 
      

  6.   

    public static void ExportExcel(ref System.Web.UI.WebControls.Repeater rp, string strFileName)
            {
                strFileName    = System.Web.HttpUtility.UrlEncode(strFileName,System.Text.Encoding.UTF8);
                
                System.Web.HttpContext.Current.Response.Clear(); 
                System.Web.HttpContext.Current.Response.Buffer = true; 
                System.Web.HttpContext.Current.Response.Charset = "gb2312";
                System.Web.HttpContext.Current.Response.AppendHeader("Content-Disposition", "online; filename=" + strFileName + ".xls");
                System.Web.HttpContext.Current.Response.ContentEncoding = System.Text.Encoding.GetEncoding("gb2312");
                System.Web.HttpContext.Current.Response.ContentType = "application/ms-excel";
             
                System.Globalization.CultureInfo myCItrad = new System.Globalization.CultureInfo("zh-CN",true);
                System.IO.StringWriter oStringWriter = new System.IO.StringWriter(myCItrad); 
                System.Web.UI.HtmlTextWriter oHtmlTextWriter = new System.Web.UI.HtmlTextWriter(oStringWriter);
                 
                rp.RenderControl(oHtmlTextWriter); 
             
                rp = null;
                System.Web.HttpContext.Current.Response.Write(oStringWriter.ToString().Replace("<td","<td STYLE='MSO-NUMBER-FORMAT:\\@'"));
                System.Web.HttpContext.Current.Response.Buffer = false; 
                System.Web.HttpContext.Current.Response.End();
            }http://topic.csdn.net/u/20090914/09/382d4e17-12e0-45e0-8d9d-857c5011fe05.html
      

  7.   

    //对于repeater数据Excel导出System.IO.StringWriter sw = new System.IO.StringWriter();
            System.Web.UI.HtmlTextWriter hw = new System.Web.UI.HtmlTextWriter(sw);
            this.OrderList.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=gbk\"><title>Copyright by SDU</title></head><body><center>");  出现乱码就把gbk换成auto
            Response.Write(sw.ToString());
            Response.Write("</center></body></html>");
            Response.End();