internal static int GetValueRow(Worksheet worksheet, SheetArea area, int row, int column, SheetSpanModelBase spans) { if (string.IsNullOrEmpty(worksheet.GetText(row, column, area)) && (spans.Find(row, column) == null)) { for (int i = row + 1; i < worksheet.RowCount; i++) { if (!string.IsNullOrEmpty(worksheet.GetText(i, column, area))) { return(i); } } } return(row); }