C#导出Excel
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(); } |
