导出EXCEL和WORD

原先使用的方法，总是会时不时的乱码出错

 

后去了几个国外的.net论坛，找到了一些不错的代码。现共享下！

 

".dwf": "Application/x-dwf";
".pdf": "Application/pdf";
".doc": "Application/vnd.ms-word";
".ppt": "Application/vnd.ms-powerpoint";
".pps": "Application/vnd.ms-powerpoint";
".xls": "Application/vnd.ms-excel";
default: "Application/octet-stream";

 

导出WORD。兼容2003-2007 public static void Export(string fileName, System.Web.UI.Control control, System.Web.HttpResponse response) { response.Clear(); response.Buffer = true; response.Charset = "utf-8";//"GB2312"; response.AppendHeader("Content-Disposition", "attachment;filename=" + fileName ); // 如果设置为 GetEncoding("GB2312");导出的文件将会出现乱码！！！ response.ContentEncoding = System.Text.Encoding.UTF8; response.ContentType = "Application/vnd.ms-word"; control.Page.EnableViewState = false; System.Globalization.CultureInfo Cul = new System.Globalization.CultureInfo("ZH-CN", true); System.IO.StringWriter oStringWriter = new System.IO.StringWriter(); System.Web.UI.HtmlTextWriter oHtmlTextWriter = new System.Web.UI.HtmlTextWriter(oStringWriter); try { control.RenderControl(oHtmlTextWriter); //response.Output.Write(oStringWriter.ToString()); response.Write(oStringWriter.ToString()); response.Flush(); response.End(); } catch (Exception e) { throw e; } finally { oHtmlTextWriter.Close(); } } //导出EXCEL。兼容2003-2007 public static void WriteToExcelFromDataGrid(DataGrid dg, string fileName) { HttpResponse Response = HttpContext.Current.Response; if(dg.Items.Count > 0) { Response.Clear(); Response.ClearHeaders(); Response.Buffer=true; Response.Charset="GB2312"; Response.AppendHeader("Content-Disposition","attachment;filename=" +System.Web.HttpUtility.UrlEncode(fileName,System.Text.Encoding.UTF8) + ".xls"); Response.ContentEncoding=System.Text.Encoding.UTF8;//设置输出流为简体中文 Response.ContentType = "application/vnd.ms-excel"; System.IO.StringWriter sw = new System.IO.StringWriter(); System.Web.UI.HtmlTextWriter hw = new HtmlTextWriter(sw); dg.RenderControl(hw); Response.Write(sw); Response.End(); } else { Response.Write ("<mce:script type="text/javascript"><!-- alert('没有数据可以导出') // --></mce:script>"); return; } }