/// <summary> /// 导出Excel Datatable版本 /// </summary> /// <param name="dt">导出的Datatable</param> /// <param name="ExcelName">导出EXCEL的名称 不需要要带有扩展名_xls</param> public static void NewExportExcelScore(DataTable dt, string Title, string colHeaders, int cl) { HttpResponse resp = System.Web.HttpContext.Current.Response; string ExcelName = Title + DateTime.Now.ToString("yyyyMMddHHmmss"); resp.ContentEncoding = System.Text.Encoding.GetEncoding("UTF-8"); resp.AppendHeader("Content-Disposition", "attachment;filename=" + ExcelName + ".xls"); string ls_item = ""; DataRow[] myRow = dt.Select();//可以类似dt.Select("id>10")之形式达到数据筛选目的 int i = 0; //int cl = dt.Columns.Count; //取得数据表各列标题，各标题之间以t分割，最后一个列标题后加回车符 resp.Write("<html><head><meta http-equiv="Content-Type" content="text/html; charset=utf-8" /></head><body><table border=1><tr style=" Gray 1px solid;text-align:center">"); //for (i = 0; i < cl; i++) //{ // colHeaders += "<th>" + dt.Columns[i].Caption.ToString() + "</th>"; //} resp.Write(colHeaders + "</tr>"); //向HTTP输出流中写入取得的数据信息 //逐行处理数据 foreach (DataRow row in myRow) { //当前行数据写入HTTP输出流，并且置空ls_item以便下行数据 ls_item = "<tr bgcolor=#ABCDC1>"; for (i = 0; i < cl; i++) { if (i == (cl - 1))//最后一列，加n { ls_item += "<td>" + row[i].ToString() + "</td></tr>"; } else { if (i == 2) { ls_item += "<td style='vnd.ms-excel.numberformat:@'>" + " " + row[i].ToString() + "</td>";//到处后已字符形式显示 } else { ls_item += "<td>" + row[i].ToString() + "</td>"; } } } resp.Write(ls_item); } resp.Write("</table></body></html>"); resp.End(); }