/// <summary> /// Workbook2EntityList /// </summary> /// <typeparam name="TEntity">EntityType</typeparam> /// <param name="workbook">excel workbook</param> /// <param name="sheetIndex">sheetIndex</param> /// <returns>entity list</returns> public static List<TEntity> ToEntityList<TEntity>([NotNull] this IWorkbook workbook, int sheetIndex) where TEntity : new() { if (workbook.NumberOfSheets <= sheetIndex) { throw new ArgumentOutOfRangeException(nameof(sheetIndex), string.Format(Resource.IndexOutOfRange, nameof(sheetIndex), workbook.NumberOfSheets)); } var sheet = workbook.GetSheetAt(sheetIndex); return NpoiHelper.SheetToEntityList<TEntity>(sheet, sheetIndex); }
/// <summary> /// Sheet2EntityList /// </summary> /// <typeparam name="TEntity">EntityType</typeparam> /// <param name="sheet">excel sheet</param> /// <param name="sheetIndex">sheetIndex</param> /// <returns>entity list</returns> public static List<TEntity> ToEntityList<TEntity>([NotNull] this ISheet sheet, int sheetIndex) where TEntity : new() => NpoiHelper.SheetToEntityList<TEntity>(sheet, sheetIndex);