/// <summary>
/// 将泛型数据转换为excel的row
/// </summary>
/// <typeparam name="T"></typeparam>
/// <param name="t"></param>
/// <returns></returns>
private static List <ExcelColumn> entityToExcelRow <T>(T t)
{
ReflectEntityProp <T> reflectT = new ReflectEntityProp <T>();
List <Column> columnList = ReflectEntityProp <T> .reflectEntityValue(t, reflectT.table.columns);
List <ExcelColumn> row = new List <ExcelColumn>();
for (int i = 0; i < columnList.Count; i++)
{
ExcelColumn excelColumn = new ExcelColumn();
excelColumn.ColumnOrder = i;
excelColumn.ColumnContent = columnList[i].content;
excelColumn.ColumnType = columnList[i].type;
row.Add(excelColumn);
}
return(row);
}
/// <summary>
/// 根据类 创建表头
/// </summary>
/// <typeparam name="T"></typeparam>
/// <param name="wb"></param>
/// <param name="style">表头单元格格式</param>
public static void createExcelColumns <T>(ref HSSFWorkbook wb, ICellStyle style)
{
ReflectEntityProp <T> reflectT = new ReflectEntityProp <T>();
createExcelColumns(ref wb, reflectT.table.name, reflectT.table.columns, style);
}