除调用excel类，给每个单元格赋值外还可以使用另一种简单的方法
protected void EduceExcel(DataTable dt, string FileName)
{
HttpContext.Current.Response.Clear();
HttpContext.Current.Response.Buffer = true;//设置缓冲输出
HttpContext.Current.Response.Charset = "GB2312";//设置输出流的HTTP字符集
HttpContext.Current.Response.AppendHeader("Content-Disposition", "attachment;filename=\"" + System.Web.HttpUtility.UrlEncode(FileName, System.Text.Encoding.UTF8) + ".xls\"");
HttpContext.Current.Response.ContentEncoding = System.Text.Encoding.GetEncoding("GB2312");
HttpContext.Current.Response.ContentType = "application/ms-";
//_page.EnableViewState = false;//是否保持视图状态
HttpContext.Current.Response.Write(HTML(dt));
HttpContext.Current.Response.End();
}
private string HTML(DataTable dt)
{
StringBuilder strHtml = new StringBuilder();
int I = dt.Columns.Count;
strHtml.Append("<table>");
strHtml.Append("<tr>");
for (int j = 0; j < I; j++)
{
strHtml.Append("<td>" + dt.Columns[j].ColumnName + "</td>");
}
strHtml.Append("</tr>");
//int ii = 1;
foreach (DataRow dr in dt.Rows)
{
strHtml.Append("<tr>");
//int I = dr.Table.Columns.Count;
for (int i = 0; i < I; i++)
{
strHtml.Append(" <td>" + dr[i].ToString() + "</td>");
}
strHtml.Append("</tr>");
}
strHtml.Append("</table>");
return strHtml.ToString();
}