public Report(ExcelWorksheet worksheet, TranslationSerialization translationSerialization) { if (worksheet == null) { return; } _translationSerialization = translationSerialization; _translatedHeaders = new List <Header>(); Employees = GetEmployees(worksheet); Headers = GetHeaders(worksheet); foreach (var employee in Employees) { employee.FillDays(worksheet, Headers); } TranslateHeaders(); }
public static Report Create(string reportFile, TranslationSerialization translationSerialization) { var excelFile = new FileInfo(reportFile); if (string.Equals(excelFile.Extension, ".xls", System.StringComparison.OrdinalIgnoreCase)) { excelFile = new FileInfo(ConvertExcel.XlsToXlsx(reportFile)); } using (var excelWorksheet = new ExcelPackage(excelFile).Workbook.Worksheets[1]) { if (excelWorksheet.Cells[1, 2].Text != "Department Code") { throw new FileLoadException("Incorrect report file"); } return(new Report(excelWorksheet, translationSerialization)); } }