导出EXCEL和WORD

来源：互联网发布：查看ubuntu 有哪些字体编辑：程序博客网时间：2024/04/28 14:55

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

后去了几个国外的.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-2007public 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-2007public 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"></mce:script>");return;}}