Asp.Net导出Excel表格之二（HttpContext.Current.Response）

DataTable dt = bllUser.GetUserInfoList(cateId);
HttpContext.Current.Response.Clear();
HttpContext.Current.Response.Charset = "UTF-8";
HttpContext.Current.Response.ContentType = "application/vnd.ms-xls";
HttpContext.Current.Response.AddHeader("content-disposition", "attachment;filename=" + FileName + ".xlsx");
StringBuilder table = new StringBuilder();
table.Append("<table><tr>");
for (int i = 0; i < dt.Columns.Count; i++)
{
table.Append("<td>");
table.Append(dt.Columns[i].Caption.ToString());//表格的标题
table.Append("</td>");
}
table.Append("</tr>");
for (int j = 0; j < dt.Rows.Count; j++)
{
table.Append("<tr>");
for (int k = 0; k < dt.Columns.Count; k++)
{
table.Append("<td style='vnd.ms-excel.numberformat:@'>");
table.Append(dt.Rows[j][k].ToString());
table.Append("</td>");
}
table.Append("</tr>");
}
table.Append("</table>");
HttpContext.Current.Response.Write(table);
HttpContext.Current.Response.End();