/// <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); }