c# List转DataTable

将List转成DataTable;

1、定义要导出的字段名字和实体字段名字：

public Tuple<string, string> GetDataMergeTitle()
{
    string title = "会员号,姓名,身份证信息,配偶名称,配偶身份证信息,资格,留座,资格2,留座2,手机,类型";
    string field = "MelaId,CustomerName,PurchaserIDNumber,SpouseName,SpouseIDNumber,QualificationOne,ReserveSeatOne,QualificationTwo,ReserveSeatTwo,PhoneNumber,Type";
 
    return Tuple.Create(title, field);
}

2、List转成DataTable

public static DataTable ToDataTable(IList list)
{
    DataTable result = new DataTable();
    if (list.Count > 0)
    {
        PropertyInfo[] propertys = list[0].GetType().GetProperties();
        foreach (PropertyInfo pi in propertys)
        {
            //result.Columns.Add(pi.Name, pi.PropertyType);
 
            Type colType = pi.PropertyType;
            if ((colType.IsGenericType) && (colType.GetGenericTypeDefinition() == typeof(Nullable<>)))
            {
                colType = colType.GetGenericArguments()[0];
            }
            result.Columns.Add(new DataColumn(pi.Name, colType));
        }
        for (int i = 0; i < list.Count; i++)
        {
            ArrayList tempList = new ArrayList();
            foreach (PropertyInfo pi in propertys)
            {
                object obj = pi.GetValue(list[i], null) == null ? DBNull.Value : pi.GetValue(list[i], null);
                tempList.Add(obj);
            }
            object[] array = tempList.ToArray();
            result.LoadDataRow(array, true);
        }
    }
    return result;
 
}

3、导出到Excel：

try
{
    Worksheet sheet = wb.Worksheets[0];
    sheet.Name = "年会门票管理";
 
    // 为单元格添加样式
    Aspose.Cells.Style style = wb.CreateStyle();
    style.HorizontalAlignment = Aspose.Cells.TextAlignmentType.Center;  //设置居中
    style.Font.Size = 12;//文字大小
    style.Font.IsBold = true;//粗体
    style.HorizontalAlignment = TextAlignmentType.Center;//文字居中
    int rowIndex = 0;
    for (int i = 0; i < b.Count(); i++)
    {
        sheet.Cells[rowIndex, i].PutValue(b[i]);
        sheet.Cells[rowIndex, i].SetStyle(style);
        sheet.Cells.SetColumnWidth(i, 10);//设置宽度
    }
    for (int i = 0; i < dt.Rows.Count; i++)//遍历DataTable行
    {
        for (int j = 0; j < field.Count(); j++)
        {
            sheet.Cells[i + 1, j].PutValue(dt.Rows[i][field[j]].ToString());
        }
 
    }
}
catch (Exception e)
{
 
}
string filename = strdate + "MeetingTicketManagerExcel.xlsx";
string path = Server.MapPath("~\\UploadFile\\" + filename);
wb.Save(path);
wb = null;
return File(path, "application/vnd.ms-excel", strdate + "MeetingTicketManagerExcel.xlsx");