asp.net DataTable导出Excel

1. public static void DataTableExcel(DataTable dtData, string fileName)  
2.         {  
3.   
4.             System.Web.UI.WebControls.DataGrid dgExport = null;  
5.             // 当前对话   
6.             System.Web.HttpContext curContext = System.Web.HttpContext.Current;  
7.             // IO用于导出并返回excel文件   
8.             System.IO.StringWriter strWriter = null;  
9.             System.Web.UI.HtmlTextWriter htmlWriter = null;  
10.   
11.             if (dtData != null)  
12.             {  
13.                 curContext.Response.Clear();  
14.                 curContext.Response.Buffer = true;  
15.                 // 设置了类型为中文防止乱码的出现  
16.                 curContext.Response.Charset = "utf-8";//原来是curContext.Response.Charset = "GB2312";下面那个一样，都是后来改的  
17.                 System.Globalization.CultureInfo myCItrad = new System.Globalization.CultureInfo("ZH-CN", true);  
18.                 // 设置输出流为简体中文  
19.                 curContext.Response.ContentEncoding = System.Text.Encoding.GetEncoding("utf-8");  
20.                 // 定义输出文件和文件名  
21.                 curContext.Response.AppendHeader("Content-Disposition", "attachment;filename=" + System.Web.HttpUtility.UrlEncode(fileName, Encoding.UTF8).ToString() + ".xls");  
22.   
23.                 // 设置编码和附件格式   
24.                 curContext.Response.ContentType = "application/vnd.ms-excel";  
25.                 //this.EnableViewState = false;  
26.   
27.                 // 导出excel文件  
28.                 strWriter = new System.IO.StringWriter(myCItrad);  
29.                 htmlWriter = new System.Web.UI.HtmlTextWriter(strWriter);  
30.   
31.                 // 为了解决dgData中可能进行了分页的情况，需要重新定义一个无分页的DataGrid   
32.                 dgExport = new System.Web.UI.WebControls.DataGrid();  
33.                 dgExport.DataSource = dtData.DefaultView;  
34.                 dgExport.AllowPaging = false;  
35.                 dgExport.DataBind();  
36.   
37.                 // 返回客户端   
38.                 dgExport.RenderControl(htmlWriter);  
39.                 curContext.Response.Write(strWriter.ToString());  
40.                 curContext.Response.End();  
41.             }  
42.         }