C#导出Excel

最新推荐文章于 2025-05-20 11:26:11 发布

转载最新推荐文章于 2025-05-20 11:26:11 发布 · 61 阅读

CC 4.0 BY-SA版权

原文链接：http://www.cnblogs.com/xqhppt/archive/2012/08/27/2658666.html

HTML格式导出Excel

public static string ExportTable()
        {
            StringBuilder sb = new StringBuilder();

            sb.Append("<html xmlns:v=\"urn:schemas-microsoft-com:vml\"xmlns:o=\"urn:schemas-microsoft-com:office:office\"xmlns:x=\"urn:schemas-microsoft-com:office:excel\"xmlns=\".w3.org/TR/REC-html40\">");
            sb.Append("<head>");
            sb.AppendLine("<meta http-equiv=\"Content-Type\" content=\"text/html; charset=utf-8\">");
            sb.Append("</head>");
            sb.Append("<body>");

            sb.AppendLine("<table cellspacing=\"0\" cellpadding=\"5\" rules=\"all\" border=\"1\" width=\"800px\">");

            sb.AppendLine("<tr style=\"font-weight: bold; white-space: nowrap;width:800px;\">");
            sb.Append("<td style=\"width:60px;\">序</td>");
            sb.Append("<td style=\"width:200px;\">姓名</td>");
            sb.Append("<td style=\"width:100px;\">年龄</td>");
            sb.Append("</tr>");

            Random rm = new Random();

            for (int i = 0; i < 100; i++)
            {
                sb.Append("<tr>");
                sb.AppendFormat("<td>{0}</td>", i + 1);
                sb.AppendFormat("<td>张{0}</td>", i + 1);
                sb.AppendFormat("<td>{0}</td>", rm.Next(0,100));
                sb.Append("</tr>");
            }

            sb.AppendLine("</table>");
            sb.Append("</body>");
            sb.Append("</html>");

            return sb.ToString();
        }

        public static void ExportToExcel(Page page)
        {
            page.Response.Clear();
            page.Response.Buffer = true;
            //page.Response.Charset = "GB2312";
            page.Response.AppendHeader("Content-Disposition", "attachment;filename=" + System.Web.HttpUtility.UrlEncode("导出Excel", System.Text.Encoding.UTF8) + ".xls");
            page.Response.ContentEncoding = System.Text.Encoding.UTF8;
            page.Response.ContentType = "application/ms-excel";
            page.EnableViewState = false;
            page.Response.Write(ExportTable());
            page.Response.End();
        }

转载于:https://www.cnblogs.com/xqhppt/archive/2012/08/27/2658666.html