Exemple #1
0
 /// <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);
 }
Exemple #2
0
 /// <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);