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