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

最新推荐文章于 2024-08-20 22:18:52 发布

goding

最新推荐文章于 2024-08-20 22:18:52 发布

阅读量784

点赞数

文章标签： datagrid excel office 网格 html xml

 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

goding

关注

0
点赞
踩
1

收藏

觉得还不错? 一键收藏
0
评论
datagrid导出 Excel 时，如何保留显示网格线

public void toexcel(System.Web.UI.WebControls.DataGrid datagrid) { System.Web.HttpContext.Current.Response.Clear(); System.Web.HttpContext.Current.Response
复制链接

扫一扫