protected internal virtual void ReadFromExcel(ExcelWorksheet excelWorksheet, bool ignoreErrorRows = false)
{
if (ReadOnly)
{
return;
}
ExcelReadingWorksheetException = null;
foreach (var columnBase in Columns)
{
columnBase.BeforeReadAll();
}
ReadDataFromExcel(excelWorksheet);
if (!ignoreErrorRows && ExcelReadingWorksheetException != null)
{
throw new InvalidOperationException("Ошибка чтения Excel-файла.\n" + ExcelReadingWorksheetException.Message);
}
}
protected override void ReadDataFromExcel(ExcelWorksheet excelWorksheet)
{
ExcelReadingWorksheetException = null;
var rowsCount = excelWorksheet.Dimension.End.Row;
for (var rowNumber = HeaderRowsCount + 1; rowNumber <= rowsCount; rowNumber++)
{
try
{
var entity = ReadEntityFromExcel(excelWorksheet, rowNumber);
AddEntity(entity);
}
catch (ExcelException e)
{
if (ExcelReadingWorksheetException == null)
{
ExcelReadingWorksheetException = new ExcelReadingWorksheetException();
}
ExcelReadingWorksheetException.ExcelReadingCellExceptions.Add((ExcelReadingCellException)e);
}
}
}
