DataTable数据导入到Excel

public class ExcelHelper { // Excel导出 public void Export(GridView dgExport, DataTable dtData) { System.Web.HttpContext curContext = System.Web.HttpContext.Current; // IO用于导出并返回excel文件 System.IO.StringWriter strWriter = null; System.Web.UI.HtmlTextWriter htmlWriter = null; if (dtData != null) { // 设置编码和附件格式 curContext.Response.Clear(); curContext.Response.ClearContent(); curContext.Response.Buffer = true; curContext.Response.ContentType = "application/vnd.ms-excel"; curContext.Response.ContentEncoding = System.Text.Encoding.GetEncoding("utf-7"); curContext.Response.Charset = "GB2312"; curContext.Response.AppendHeader("content-disposition", "filename=/"" + System.Web.HttpUtility.UrlEncode(dtData.TableName, System.Text.Encoding.UTF8) + ".xls/""); // 导出excel文件 strWriter = new System.IO.StringWriter(); htmlWriter = new System.Web.UI.HtmlTextWriter(strWriter); HtmlForm frm = new HtmlForm(); frm.Attributes["runat"] = "server"; frm.Controls.Add(dgExport); dgExport.DataSource = dtData.DefaultView; dgExport.DataBind(); // 返回客户端 dgExport.RenderControl(htmlWriter); curContext.Response.Write(strWriter.ToString()); curContext.Response.End(); } } }