// 导出数据 public static void ToExcel(System.Web.UI.WebControls.DataGrid DataGrid1, string StrFileName, string StrTitle, string StrHead) { System.IO.StringWriter ObjSw = new System.IO.StringWriter(); System.Web.UI.HtmlTextWriter ObjHw = new System.Web.UI.HtmlTextWriter(ObjSw); FrontDecorator(ObjHw); if (StrTitle != "") ObjHw.Write(StrTitle + "<br>"); if (StrHead != "") ObjHw.Write(StrHead + "<br>"); DataGrid1.EnableViewState = false; DataGrid1.RenderControl(ObjHw); RearDecorator(ObjHw); System.Web.HttpResponse ObjResponse = System.Web.HttpContext.Current.Response; ObjResponse.Clear(); ObjResponse.Buffer = true; ObjResponse.ContentEncoding = System.Text.Encoding.GetEncoding("utf-7"); ObjResponse.ContentType = "application/vnd.ms-excel"; ObjResponse.AddHeader("Content-Disposition", "attachment; filename=" + StrFileName + ".xls"); ObjResponse.Charset = "gb2312"; ObjResponse.Write(ObjSw.ToString()); //response.End(); HttpContext.Current.ApplicationInstance.CompleteRequest(); }