private IEnumerable <int> GetNextRowIndexesContainingDates(
IWorksheetReader worksheetReader,
IEnumerable <ExcelCellCoordinates> nextRowsCoordinatesCollection)
{
if (nextRowsCoordinatesCollection.Count() == 0)
{
return(new int[0]);
}
var worksheetIndex = nextRowsCoordinatesCollection.First().WorksheetIndex;
var datesColumnIndex = nextRowsCoordinatesCollection.First().ColumnIndex;
return(nextRowsCoordinatesCollection
.Select(coordinates => coordinates.RowIndex)
.Where(rowIndex =>
{
try
{
var nextRowCoordinates = new ExcelCellCoordinates(worksheetIndex, rowIndex, datesColumnIndex);
return worksheetReader.GetCellDateTimeAsUTC(nextRowCoordinates) != default(DateTime);
}
catch
{
return false;
}
})
.ToArray());
}
