string filepath = Utils.GetMapPath("/upload/excel/"); filepath = filepath + fileName + ".xls"; string tempFilePath = Utils.GetMapPath("/ExcelTemplate/export_comment_excel.xlsx"); DataSet ds = new BLL.Comment().GetList(0, strWhere, "addtime desc"); DataTable exportDT = new DataTable(); exportDT.Columns.Add("姓名", typeof(string)); exportDT.Columns.Add("评价等级(星星数)", typeof(int)); exportDT.Columns.Add("评价内容", typeof(string)); exportDT.Columns.Add("评价时间", typeof(string)); exportDT.Columns.Add("状态", typeof(string)); exportDT.Columns.Add("原因", typeof(string)); if (ds != null && ds.Tables[0].Rows.Count > 0) { for (int i = 0; i < ds.Tables[0].Rows.Count; i++) { DataRow dr = exportDT.NewRow(); dr["姓名"] = ds.Tables[0].Rows[i]["Name"].ToString(); dr["评价等级(星星数)"] = ds.Tables[0].Rows[i]["level"].ToString(); dr["评价内容"] = ds.Tables[0].Rows[i]["content"].ToString(); dr["评价时间"] = ds.Tables[0].Rows[i]["addtime"].ToString(); dr["状态"] = GetStatus(ds.Tables[0].Rows[i]["status"].ToString()); dr["原因"] = ds.Tables[0].Rows[i]["reason"].ToString(); exportDT.Rows.Add(dr); } } Common.ExcelToData.ExportExcel(tempFilePath, filepath, exportDT, "评论信息"); GC.Collect();//行销毁 HttpContext.Current.Response.Buffer = true; HttpContext.Current.Response.Clear(); HttpContext.Current.Response.ContentType = "application/ms-excel"; HttpContext.Current.Response.AddHeader("Content-Disposition", "attachment;filename=" + fileName + "(" + DateTime.Now.ToString("yyMMddHHmm") + ").xls"); HttpContext.Current.Response.WriteFile(filepath); HttpContext.Current.Response.Flush(); File.Delete(filepath); HttpContext.Current.Response.End();