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