public TempCommentHolders(ExcelStream excelStream)
{
excelStream.Select(1);
int startRow = excelStream.Start.Item1 + 1; //Becuase we are ignoring the headings.
int startCol = excelStream.Start.Item2;
List <string> emptyString = new List <string> {
"", " ", string.Empty, null
};
List <TempCommentHolder> toAdd = new List <TempCommentHolder>();
for (int rowID = startRow; rowID <= excelStream.RowCount; rowID++)
{
toAdd.Add(new TempCommentHolder()
{
Date = (DateTime)excelStream.GetCellData(rowID, startCol, true),
Time = (!emptyString.Contains((string)excelStream.GetCellData(rowID, startCol + 1))) ?
(TimeSpan?)TimeSpan.Parse(((string)excelStream.GetCellData(rowID, startCol + 1)).Replace(';', ':')) : null,
MorningFlow = (!emptyString.Contains((string)excelStream.GetCellData(rowID, startCol + 3))) ?
(double?)double.Parse((string)excelStream.GetCellData(rowID, startCol + 3)) : null,
AfternoonFlow = (!emptyString.Contains((string)excelStream.GetCellData(rowID, startCol + 4))) ?
(double?)double.Parse((string)excelStream.GetCellData(rowID, startCol + 4)) : null,
Comment = (string)excelStream.GetCellData(rowID, startCol + 5)
});
}
Items = toAdd.ToArray();
}
private void OnDeserialized()
{
ExcelStream.Load();
}
