datagrid导出 Excel 时，如何保留显示网格线

最新推荐文章于 2025-11-30 22:09:06 发布

转载最新推荐文章于 2025-11-30 22:09:06 发布 · 819 阅读

文章标签：

本文介绍了一种在ASP.NET中将DataGrid控件的内容导出为Excel文件的方法。通过设置HTTP响应头和使用HTMLTextWriter来渲染DataGrid，可以生成带有Excel元数据的HTML页面，并最终提供给用户下载。

 public void toexcel(System.Web.UI.WebControls.DataGrid datagrid)

        {

            System.Web.HttpContext.Current.Response.Clear();

            System.Web.HttpContext.Current.Response.Write("<html xmlns:x=/"urn:schemas-microsoft-com:office:excel/">");

            System.Web.HttpContext.Current.Response.Write("<head>");

            System.Web.HttpContext.Current.Response.Write("<!--[if gte mso 9]><xml>");

            System.Web.HttpContext.Current.Response.Write("<x:ExcelWorkbook>");

            System.Web.HttpContext.Current.Response.Write("<x:ExcelWorksheets>");

            System.Web.HttpContext.Current.Response.Write("<x:ExcelWorksheet>");

            System.Web.HttpContext.Current.Response.Write("<x:Name>sheet1</x:Name>");

            System.Web.HttpContext.Current.Response.Write("<x:WorksheetOptions>");

            System.Web.HttpContext.Current.Response.Write("<x:Print>");

            System.Web.HttpContext.Current.Response.Write("<x:ValidPrinterInfo/>");

            System.Web.HttpContext.Current.Response.Write("</x:Print>");

            System.Web.HttpContext.Current.Response.Write("</x:WorksheetOptions>");

            System.Web.HttpContext.Current.Response.Write("</x:ExcelWorksheet>");

            System.Web.HttpContext.Current.Response.Write("</x:ExcelWorksheets>");

            System.Web.HttpContext.Current.Response.Write("</x:ExcelWorkbook>");

            System.Web.HttpContext.Current.Response.Write("</xml>");

            System.Web.HttpContext.Current.Response.Write("<![endif]--> ");

            System.Web.HttpContext.Current.Response.Write("</head>");

            System.Web.HttpContext.Current.Response.Write("<body>");

            System.Web.HttpContext.Current.Response.AppendHeader("Content-Disposition", "attachment;filename=" + System.DateTime.Now.ToFileTime() + ".xls");

            System.Web.HttpContext.Current.Response.Charset = "UTF-8";

            System.Web.HttpContext.Current.Response.ContentEncoding = System.Text.Encoding.Default;

            System.Web.HttpContext.Current.Response.ContentType = "application/ms-excel";

            //loggrid.Page.EnableViewState   =false;           

            System.IO.StringWriter tw = new System.IO.StringWriter();

            System.Web.UI.HtmlTextWriter hw = new System.Web.UI.HtmlTextWriter(tw);

            datagrid.RenderControl(hw);

            System.Web.HttpContext.Current.Response.Write(tw.ToString());

            System.Web.HttpContext.Current.Response.Write("<font style=/"color:white;/">.</font></body>");

            System.Web.HttpContext.Current.Response.Write("</html>");

            System.Web.HttpContext.Current.Response.End();

        }

原帖子地址: http://forums.asp.net/1674188/ShowThread.aspx