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