public static ExcelElement <Sheet> FillCellReferences(this ExcelElement <Sheet> sheet)
{
sheet
.GetRows()
.FillCellReferences()
.ToArray();
return(sheet);
}
/// <summary>
/// Maps rows to entities with specified <paramref name="parserProvider"/>.
/// </summary>
/// <typeparam name="T">Entity type.</typeparam>
/// <param name="sheet">Sheet.</param>
/// <param name="parserProvider"><see cref="IParserProvider"/>.</param>
/// <param name="factory">Factory.</param>
/// <returns>Enumeration of <typeparamref name="T"/>.</returns>
public static IEnumerable <T> GetRowsAs <T>(
this ExcelElement <Sheet> sheet,
IParserProvider parserProvider,
Func <IReadOnlyList <IPropertyValue>, T> factory = null)
{
if (factory == null)
{
factory = list => (T)Activator.CreateInstance(typeof(T), list);
}
if (sheet.IsEmpty())
{
return(Array.Empty <T>());
}
return(sheet
.GetRows()
.MapRows(parserProvider, factory));
}