将页面上的内容导出到Excel

             <asp:Button ID="lkbExport" runat="server" Name="Save" Text="导出到excel" class="button_h_b"
                Style="display: block" OnClick="lkbExport_Click" />

前台的导出按钮

 

 

public override void VerifyRenderingInServerForm(Control control)    

{        

   // Confirms that an HtmlForm control is rendered for    

}    

#region export excel linkbutton    

protected void lkbExport_Click(object sender, EventArgs e)    

{        

   //说明：earDiv  是页面上的div ，业就是你想要导出的这个div里边包括的内容，也可以是其它控件，也就是你给它什么控件，它就会把你这个控件里的内容导出到Excel中

     if (year_list.Text.ToString().Trim() != "")        

   {           

      stryear = year_list.Text.ToString().Trim();        

   }        

     iniListPanel(stryear);     //初始化页面的方法   

   //Catch缓存给权限        

   HttpContext.Current.Response.ClearHeaders();        

    HttpContext.Current.Response.AppendHeader("Expires ", System.DateTime.Now.AddMinutes(30).ToString());        

   HttpContext.Current.Response.AppendHeader("Pragma ", "public ");        

   HttpContext.Current.Response.AppendHeader("Cache-Control ", "must-revalidate,   post-check=0,   pre-check=0 ");        

    HttpContext.Current.Response.AppendHeader("Cache-Control ", "public ");

        //HttpContext.Current.Response.Charset = "UTF-8";        

       //HttpContext.Current.Response.ContentEncoding = System.Text.Encoding.UTF7;        

       //HttpContext.Current.Response.AppendHeader("Content-Disposition", "attachment;filename=export"+DateTime.Now.Ticks.ToString()+".xls");        

       //HttpContext.Current.Response.ContentType = "application/ms-excel";        

   HttpContext.Current.Response.Charset = "GB2312";        

   Response.Write("<meta http-equiv=Content-Type content=text/html;charset=GB2312>");        

   Response.AppendHeader("Content-Disposition", "attachment;filename=export" + DateTime.Now.Ticks.ToString() + ".xls");        

   Response.ContentEncoding = System.Text.Encoding.GetEncoding("GB2312");        

   Response.ContentType = "application/vnd.xls";//设置输出文件类型为excel文件。         y

   earDiv.Page.EnableViewState = false;        

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

   HtmlTextWriter hw = new HtmlTextWriter(tw);        

     this.yearDiv.RenderControl(hw);

        HttpContext.Current.Response.Write(tw.ToString());        

         HttpContext.Current.Response.End();

    }     #endregion