首页 > 代码库 > 将IList、DataTable数据导出到Excel
将IList、DataTable数据导出到Excel
/// <summary> /// IList导出Excel /// </summary> /// <typeparam name="T"></typeparam> /// <param name="list">集合</param> /// <param name="dataColumn">字段</param> /// <param name="fileName"></param> public static void ListToExcel<T>(IList list, string[] dataColumn, string fileName) { HttpContext.Current.Response.ContentType = "application/vnd.ms-excel"; HttpContext.Current.Response.ContentEncoding = System.Text.Encoding.UTF8; HttpContext.Current.Response.Charset = "Utf-8"; HttpContext.Current.Response.AppendHeader("Content-Disposition", "attachment;filename=" + HttpUtility.UrlEncode(fileName + ".xls", System.Text.Encoding.UTF8)); StringBuilder sbHtml = new StringBuilder(); sbHtml.AppendLine("<meta http-equiv=\"Content-Type\" content=\"text/html; charset=utf-8\">"); sbHtml.AppendLine("<table cellspacing=\"0\" cellpadding=\"5\" rules=\"all\" border=\"1\">"); //写出列名 sbHtml.AppendLine("<tr style=\"background-color: #FFE88C;font-weight: bold; white-space: nowrap;\">"); foreach (string item in dataColumn) { string[] stritem = item.Split(‘:‘); sbHtml.AppendLine("<td>" + stritem[0] + "</td>"); } sbHtml.AppendLine("</tr>"); //写数据 foreach (T entity in list) { Hashtable ht = HashtableHelper.GetModelToHashtable<T>(entity); sbHtml.Append("<tr>"); foreach (string item in dataColumn) { string[] stritem = item.Split(‘:‘); sbHtml.Append("<td>").Append(ht[stritem[1]]).Append("</td>"); } sbHtml.AppendLine("</tr>"); } sbHtml.AppendLine("</table>"); HttpContext.Current.Response.Write(sbHtml.ToString()); HttpContext.Current.Response.End(); } /// <summary> /// DataTable导出Excel /// </summary> /// <param name="data">集合</param> /// <param name="dataColumn">字段</param> /// <param name="fileName">文件名称</param> public static void DataTableToExcel(DataTable data, string[] dataColumn, string fileName) { HttpContext.Current.Response.ContentType = "application/vnd.ms-excel"; HttpContext.Current.Response.ContentEncoding = System.Text.Encoding.UTF8; HttpContext.Current.Response.Charset = "Utf-8"; HttpContext.Current.Response.AppendHeader("Content-Disposition", "attachment;filename=" + HttpUtility.UrlEncode(fileName + ".xls", System.Text.Encoding.UTF8)); StringBuilder sbHtml = new StringBuilder(); sbHtml.AppendLine("<meta http-equiv=\"Content-Type\" content=\"text/html; charset=utf-8\">"); sbHtml.AppendLine("<table cellspacing=\"0\" cellpadding=\"5\" rules=\"all\" border=\"1\">"); //写出列名 sbHtml.AppendLine("<tr style=\"background-color: #FFE88C;font-weight: bold; white-space: nowrap;\">"); foreach (string item in dataColumn) { sbHtml.AppendLine("<td>" + item + "</td>"); } sbHtml.AppendLine("</tr>"); //写数据 foreach (DataRow row in data.Rows) { sbHtml.Append("<tr>"); foreach (string item in dataColumn) { sbHtml.Append("<td>").Append(row[item]).Append("</td>"); } sbHtml.AppendLine("</tr>"); } sbHtml.AppendLine("</table>"); HttpContext.Current.Response.Write(sbHtml.ToString()); HttpContext.Current.Response.End(); }
将IList、DataTable数据导出到Excel
声明:以上内容来自用户投稿及互联网公开渠道收集整理发布,本网站不拥有所有权,未作人工编辑处理,也不承担相关法律责任,若内容有误或涉及侵权可进行投诉: 投诉/举报 工作人员会在5个工作日内联系你,一经查实,本站将立刻删除涉嫌侵权内容。