/// <summary> /// 导出Excel的方法 /// </summary> /// <param name="dtData">先查出要导出的数据表</param> public void meDataGirdToExcel(DataTable dt) { System.Web.HttpResponse resp = System.Web.HttpContext.Current.Response; ; if (dt.Rows.Count == 0) { resp.Write(" <mce:script type="text/javascript"><!-- alert('对不起,没有查询到任何记录,无法导出') // --></mce:script>"); resp.End(); } resp.ContentEncoding = System.Text.Encoding.GetEncoding("GB2312"); resp.ContentType = "application/ms-excel"; resp.AppendHeader("Content-Disposition", "attachment;filename=HrExport.xls"); int colCount = dt.Columns.Count; System.Text.StringBuilder sb = new StringBuilder(); sb.Append(" <html> <head>/n"); sb.Append(" <meta http-equiv=/"Content-Language/" content=/"zh-cn/">/n"); sb.Append(" <meta http-equiv=/"Content-Type/" content=/"text/html; charset=gb2312/">/n"); sb.Append(" </head>/n"); sb.Append(" <table border=1>"); 查询时间 //sb.Append(" <tr> <td colspan=" + colCount + " valign=middle height=24>"); //sb.Append("查询时间:" + System.DateTime.Now.ToString() + " </td> </tr>"); //表标题 sb.Append(" <tr>/n"); for (int i = 0; i < colCount; i++) { string sCaption = dt.Columns[i].Caption.ToString(); if (sCaption.ToLower() != "id") sb.Append(" <td bgcolor=#969696> <b>" + dt.Columns[i].Caption.ToString() + " </b> </td>/n"); } //表内容 foreach (DataRow dr in dt.Rows) { sb.Append(" <tr>"); for (int j = 0; j < colCount; j++) { if (dt.Columns[j].Caption.ToString().ToLower() != "id") sb.Append(" <td style="vnd.ms-excel.numberformat:@" mce_style="vnd.ms-excel.numberformat:@">" + dr[j].ToString() + " </td>"); } sb.Append(" </tr>/n"); } sb.Append(" </table>/n"); resp.Write(sb.ToString()); resp.End(); }