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 TwentyEighthColumn_ReturnsAB()
{
const int columnIndex = 27;
const string expected = "AB";
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 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}");
}
internal void AddErrorDesc(ExcelColumnName col1, ExcelColumnName col2, string message)
{
base.Add($"Column {GetExcelColumnName((int)col1)}, {GetExcelColumnName((int)col2)}: {message}");
}
