private ExcelBlockData GetBlockData(BlockDataColumns blockDataColumns, KeyValuePair <string, SheetNavigation> sheetNavigation)
{
var sheet = _excelPackage.Workbook.Worksheets.First(sh => sh.Name == sheetNavigation.Key);
var blockHeader = GetBlockHeader(sheet, sheetNavigation.Value, blockDataColumns);
_logService.Information($"Parsing block header for '{blockHeader}'");
var parasedBlockHeader = ExcelParser.ParsedBlockHeader(blockHeader);
return(new ExcelBlockData
{
SheetName = sheetNavigation.Key,
Date = parasedBlockHeader,
ProductData = GetProductDataForBlock(sheet, sheetNavigation.Value, blockDataColumns, parasedBlockHeader)
});
}
