public void TestMethod_AllColumnsUntil_0()
{
const int source = 0;
List <string> expected = new List <string>();
List <string> result = FunctionsExcel.AllColumnsNameUntil(source);
CollectionAssert.AreEqual(result, expected);
}
public void TestMethod_AllColumnsUntil_28()
{
const int source = 28;
List <string> expected = new List <string>
{
"A", "B", "C", "D", "E", "F", "G", "H", "I", "J", "K", "L", "M", "N", "O", "P", "Q", "R", "S", "T", "U", "V", "W", "X", "Y", "Z", "AA", "AB"
};
List <string> result = FunctionsExcel.AllColumnsNameUntil(source);
CollectionAssert.AreEquivalent(result, expected);
}
public void TestMethod_AllColumnsUntil_72()
{
const int source = 72;
List <string> expected = new List <string>
{
"A", "B", "C", "D", "E", "F", "G", "H", "I", "J", "K", "L", "M", "N", "O", "P", "Q", "R", "S", "T", "U", "V", "W", "X", "Y", "Z", "AA", "AB", "AC", "AD", "AE", "AF", "AG", "AH", "AI", "AJ", "AK", "AL", "AM", "AN", "AO", "AP", "AQ", "AR", "AS", "AT", "AU", "AV", "AW", "AX", "AY", "AZ", "BA", "BB", "BC", "BD", "BE", "BF", "BG", "BH", "BI", "BJ", "BK", "BL", "BM", "BN", "BO", "BP", "BQ", "BR", "BS", "BT"
};
List <string> result = FunctionsExcel.AllColumnsNameUntil(source);
CollectionAssert.AreEquivalent(result, expected);
}
public void TestMethod_AllColumnsUntil_2()
{
const int source = 2;
List <string> expected = new List <string>
{
"A", "B"
};
List <string> result = FunctionsExcel.AllColumnsNameUntil(source);
CollectionAssert.AreEquivalent(result, expected);
}