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()); }