62,133
社区成员
![](https://csdnimg.cn/release/cmsfe/public/img/topic.427195d5.png)
![](https://csdnimg.cn/release/cmsfe/public/img/me.40a70ab0.png)
![](https://csdnimg.cn/release/cmsfe/public/img/task.87b52881.png)
![](https://csdnimg.cn/release/cmsfe/public/img/share-circle.3e0b7822.png)
/// <summary>
/// 将DataGrid数据导入到Excel
/// </summary>
/// <param name="gv">GridView控件</param>
/// <param name="strFileName">文件名</param>
/// <returns></returns>
public static void ImportExcel(System.Web.UI.WebControls.GridView gv, string strFileName)
{
System.Web.HttpContext obj = System.Web.HttpContext.Current;
obj.Response.Clear();
obj.Response.Buffer = true;
//obj.Response.Charset="GB2312";
obj.Response.AddHeader("Content-Disposition", "attachment;filename=" + HttpUtility.UrlEncode(strFileName, System.Text.Encoding.UTF8) + ".xls");
obj.Response.ContentEncoding = System.Text.Encoding.UTF8;
obj.Response.ContentType = "application/ms-excel";//设置输出文件类型为excel文件。
obj.Response.ContentType = "application/vnd.ms-excel";
System.IO.StringWriter sw = new System.IO.StringWriter();
System.Web.UI.HtmlTextWriter htw = new System.Web.UI.HtmlTextWriter(sw);
gv.RenderControl(htw);
obj.Response.Write(sw.ToString());
obj.Response.End();
}