给你一个简单的方法吧,生成csv格式的,execl也能打开,但是相对要简单很多.
StringWriter sw = new StringWriter();
DataTable dt = DBUtility.DbHelperSQL.Query("select * from VIEWwj where dcid="+TextBox1.Text).Tables[0];
foreach (DataRow dr in dt.Rows)
{
sw.WriteLine(dr["qname"] + ",'" + dr["akcontent"] + "," + dr["stime"]);
}
sw.Close();
Response.AddHeader("Content-Disposition", "attachment; filename=chenbao.csv");
Response.ContentType = "application/ms-excel";
Response.ContentEncoding = System.Text.Encoding.GetEncoding("GB2312");
Response.Write(sw);
Response.End();
把楼下的改动一下扩展名就可以生成xls的文件了,
学习