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();
}
