Asp.Net数据导出Excel报表

最新推荐文章于 2017-10-12 18:45:34 发布

旺哥萌死了

最新推荐文章于 2017-10-12 18:45:34 发布

阅读量865

点赞数

文章标签： gridview excel 报表 datagrid asp.net

本文链接：https://blog.csdn.net/watasihakami/article/details/23558997

版权

1：导出全部HTML 数据到 Excel

这种方法是将Html中的所有文档内容，包括按钮，表格，图片等所有页面内容导出为 Excel

Response.Clear();     
Response.Buffer = true;     
Response.AppendHeader("Content-Disposition","attachment;filename="+DateTime.
Now.ToString("yyyyMMdd")+".xls");           
Response.ContentEncoding = System.Text.Encoding.UTF8;   
Response.ContentType = ""application/ms-excel";   
this.EnableViewState = false;

2:从GridView控件直接导出数据到Excel

导出GridView中的数据。

   public void ExportToExcel(GridView ctl) 
  {
   Response.Clear();
   Response.Buffer = true;
   Response.Charset = "gb2312";
   Response.AppendHeader("Content-Disposition", "attachment;filename=销售报表.xls");
   Response.ContentEncoding = System.Text.Encoding.GetEncoding("gb2312");
   Response.ContentType = "application/vnd.ms-excel"; 
   ctl.Page.EnableViewState = false; 
   System.IO.StringWriter tw = new System.IO.StringWriter(); 
   System.Web.UI.HtmlTextWriter hw = new HtmlTextWriter(tw); 
   ctl.RenderControl(hw);
   
   Response.Write(tw.ToString()); 
   Response.End();
  }

3也可能是DataTable ,DataSet,datagrid等

    private void ToExcel(Control ctl, string FileName)
        {
            HttpContext.Current.Response.ContentEncoding = System.Text.Encoding.GetEncoding("GB2312");
            HttpContext.Current.Response.Charset = "GB2312";
            HttpContext.Current.Response.ContentType = "application/ms-excel";
            HttpContext.Current.Response.AppendHeader("Content-Disposition", "attachment;filename=" + "" + FileName);
            ctl.Page.EnableViewState = false;
            System.IO.StringWriter tw = new System.IO.StringWriter();
            HtmlTextWriter hw = new HtmlTextWriter(tw);
            ctl.RenderControl(hw);
            HttpContext.Current.Response.Write(tw.ToString());
            HttpContext.Current.Response.End();
        }