public void NegativeColumn_ReturnsEmpty() { const int columnIndex = -1; const string expected = ""; var result = ExcelColumnName.ColumnNameFromIndex(columnIndex); result.Should().NotBeNull(); result.Should().Be(expected); }
public void SecondColumn_ReturnsB() { const int columnIndex = 1; const string expected = "B"; var result = ExcelColumnName.ColumnNameFromIndex(columnIndex); result.Should().NotBeNull(); result.Should().Be(expected); }
public void TwentyEighthColumn_ReturnsAB() { const int columnIndex = 27; const string expected = "AB"; var result = ExcelColumnName.ColumnNameFromIndex(columnIndex); result.Should().NotBeNull(); result.Should().Be(expected); }
public void FirstColumn_ReturnsA() { const int columnIndex = 0; const string expected = "A"; var result = ExcelColumnName.ColumnNameFromIndex(columnIndex); result.Should().NotBeNull(); result.Should().Be(expected); }
/// <summary> /// /// </summary> /// <param name="rowIndex">0 index means first row in Excel</param> /// <param name="columnIndex">0 index means column A in Excel</param> /// <returns></returns> public static string CellNameFromIndex(int rowIndex, int columnIndex) { if (rowIndex < 0) { return(string.Empty); } if (columnIndex < 0) { return(string.Empty); } return($"{ExcelColumnName.ColumnNameFromIndex(columnIndex)}{rowIndex+1}"); }