按钮单击事件调用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(); }