/// <summary> /// 将DataTable 导出到Excel /// </summary> /// <param name="table">DataTable</param> public void ExportToExcel(DataTable table) { StringBuilder sbText = new StringBuilder(); try { sbText.AppendLine("<meta http-equiv=/"Content-Type/" content=/"text/html;charset=gb2312/">"); sbText.AppendLine("<table cellspacing=/"0/" cellpadding=/"5/" rules=/"all/" border=/"1/">"); //导出列名 sbText.AppendLine("<tr style="/" mce_style="/""font-weight:bold;white-space:nowrap;/">"); for (int i = 0; i < table.Columns.Count; i++) { sbText.AppendFormat("<td>{0}</td>", table.Columns[i].ColumnName); } sbText.AppendLine("</tr>"); //导出数据 foreach (DataRow row in table.Rows) { sbText.Append("<tr>"); for (int i = 0; i < table.Columns.Count; i++) { sbText.AppendFormat("<td>{0}</td>", row[i]); } sbText.AppendLine("</tr>"); } sbText.AppendLine("</table>"); Response.Clear(); Response.Buffer = true; Response.Charset = "GB2312"; Response.AppendHeader("Content-Disposition", "attachment;filename=" + DateTime.Now.ToString("yyyyMMddHHmmssfff") + ".xls"); //设置输出流编码格式 Response.ContentEncoding = System.Text.Encoding.GetEncoding("GB2312"); //设置输出文件类型为excel文件。 Response.ContentType = "application/ms-excel"; EnableViewState = false; } catch (Exception ex) { //错误处理代码 } Response.Write(sbText.ToString()); Response.End(); }