在aspx页面中将DataTable中的数据通过GridView导出到Excel中

按钮单击事件调用ExportToExcel方法

protected void ToExcel_Click(object sender, EventArgs e)
{
    CCourse cc = new CCourse();
    DataTable dt = cc.GetAllCourse();
    dt.Columns["num"].ColumnName = "编号";//设置DataTable列名

    ExportToExcel(dt, "excel");
}

将DataTable中的数据通过GridView导出到Excel中，并显示下载界面

public void ExportToExcel(DataTable tab, string filename)
{
    System.Web.UI.WebControls.DataGrid source = new System.Web.UI.WebControls.DataGrid();
    source.DataSource = tab.DefaultView;
    source.AllowPaging = false;
    source.HeaderStyle.BackColor = System.Drawing.Color.LightGray;
    source.HeaderStyle.HorizontalAlign = HorizontalAlign.Center;
    source.HeaderStyle.Font.Bold = true;
    source.DataBind();
    //防止出现乱码,加上这行可以防止在只有一行数据时出现乱码
    HttpContext.Current.Response.Write("<meta http-equiv=Content-Type content=text/html;charset=UTF-8>");

    HttpContext.Current.Response.AppendHeader("Content-Disposition", "attachment;filename=" + HttpUtility.UrlEncode(filename + ".xls", System.Text.Encoding.UTF8));
    HttpContext.Current.Response.ContentType = "application/ms-excel";

    HttpContext.Current.Response.Charset = "UTF-8";
    HttpContext.Current.Response.ContentEncoding = System.Text.Encoding.UTF8;

    //关闭控件的视图状态
    //source.Page.EnableViewState = false;

    //初始化HtmlWriter
    System.IO.StringWriter writer = new System.IO.StringWriter();
    System.Web.UI.HtmlTextWriter htmlWriter = new System.Web.UI.HtmlTextWriter(writer);
    source.RenderControl(htmlWriter);

    //输出
    HttpContext.Current.Response.Write(writer.ToString());
    HttpContext.Current.Response.End();
}