private void ReadEmployees() { FileInfo fileInfo = new FileInfo(ShiftPath); ExcelWorksheet worksheet; using (ExcelPackage package = new ExcelPackage(fileInfo)) { try { if (fileInfo.Exists) { worksheet = package.Workbook.Worksheets[CurrentDate.DayOfWeekIndex()]; int from = 5 + 1; int to = 5 + (24 * 2); for (int i = 3; i <= worksheet.Dimension.End.Row; i++) { int row = -1; if (!int.TryParse(worksheet.Cells[i, 1].Text, out row)) { continue; } var number = worksheet.Cells[i, 3].Text; var shifts = CreateShifts(worksheet.Cells[i, from, i, to]); var employee = new Employee { Number = number, Shifts = shifts }; Employees.Add(employee); } } } catch (Exception e) { throw new Exception("Error in reading shift File\n" + e.Message); } } }