/// <summary>
/// 將一組對(duì)象導(dǎo)出成EXCEL
/// </summary>
/// <typeparam name="T">要導(dǎo)出對(duì)象的類(lèi)型</typeparam>
/// <param name="objList">一組對(duì)象</param>
/// <param name="FileName">導(dǎo)出后的文件名</param>
/// <param name="columnInfo">列名信息</param>
public static void ExExcel<T>(List<T> objList, string FileName, Dictionary<string, string> columnInfo)
{
if (columnInfo.Count == 0) { return; }
if (objList.Count == 0) { return; }
//生成EXCEL的HTML
string excelStr = "";
Type myType = objList[0].GetType();
//根據(jù)反射從傳遞進(jìn)來(lái)的屬性名信息得到要顯示的屬性
List<PropertyInfo> myPro = new List<PropertyInfo>();
foreach (string cName in columnInfo.Keys)
{
PropertyInfo p = myType.GetProperty(cName);
if (p != null)
{
myPro.Add(p);
excelStr += columnInfo[cName] + "/t";
}
}
//如果沒(méi)有找到可用的屬性則結(jié)束
if (myPro.Count == 0) { return; }
excelStr += "/n";
foreach (T obj in objList)
{
foreach (PropertyInfo p in myPro)
{
excelStr += p.GetValue(obj, null) + "/t";
}
excelStr += "/n";
}
//輸出EXCEL
HttpResponse rs = System.Web.HttpContext.Current.Response;
rs.ContentEncoding = System.Text.Encoding.GetEncoding("GB2312");
rs.AppendHeader("Content-Disposition", "attachment;filename=" + FileName);
rs.ContentType = "application/ms-excel";
rs.Write(excelStr);
rs.End();
}
/// <summary>
/// 將一組對(duì)象導(dǎo)出成EXCEL
/// </summary>
/// <typeparam name="T">要導(dǎo)出對(duì)象的類(lèi)型</typeparam>
/// <param name="objList">一組對(duì)象</param>
/// <param name="FileName">導(dǎo)出后的文件名</param>
/// <param name="columnInfo">列名信息</param>
public static void ExExcel<T>(List<T> objList, string FileName, Dictionary<string, string> columnInfo)
{
if (columnInfo.Count == 0) { return; }
if (objList.Count == 0) { return; }
//生成EXCEL的HTML
StringBuilder excelStr = new StringBuilder(objList.Count * columnInfo.Count);
Type myType = objList[0].GetType();
//根據(jù)反射從傳遞進(jìn)來(lái)的屬性名信息得到要顯示的屬性
List<PropertyInfo> myPro = new List<PropertyInfo>();
foreach (string cName in columnInfo.Keys)
{
PropertyInfo p = myType.GetProperty(cName);
if (p != null)
{
myPro.Add(p);
excelStr.Append(columnInfo[cName]).Append("/t");
}
}
//如果沒(méi)有找到可用的屬性則結(jié)束
if (myPro.Count == 0) { return; }
excelStr.Append("/n");
foreach (T obj in objList)
{
foreach (PropertyInfo p in myPro)
{
excelStr.Append(p.GetValue(obj, null)).Append("/t");
}
excelStr.Append("/n");
}
//輸出EXCEL
HttpResponse rs = System.Web.HttpContext.Current.Response;
rs.ContentEncoding = System.Text.Encoding.GetEncoding("GB2312");
rs.AppendHeader("Content-Disposition", "attachment;filename=" + FileName);
rs.ContentType = "application/ms-excel";
rs.Write(excelStr);
rs.End();
}
}
