private string GetStringValueFromCell(IXLCell cell)
{
if (cell.IsMerged())
{
return(cell.MergedRange().Cell(1, 1).GetString());
}
return(cell.GetString());
}
private IXLCell GetNextCell(IXLCell current)
{
var currentRangeLastCell = current.MergedRange()?.LastCell() ?? current;
return(currentRangeLastCell.CellRight());
}