public void getExcelColumnHeaderTest()
{
int position;
string result = string.Empty;
string expected = string.Empty;
position = 27;
expected = "AA";
result = ExcelHeader.getExcelColumnHeader(position);
Assert.AreEqual(result, expected);
Console.WriteLine(String.Format("Position: {0} => {1}", position.ToString(), result));
position = 28;
expected = "AB";
result = ExcelHeader.getExcelColumnHeader(position);
Assert.AreEqual(result, expected);
Console.WriteLine(String.Format("Position: {0} => {1}", position.ToString(), result));
position = 26;
expected = "Z";
result = ExcelHeader.getExcelColumnHeader(position);
Assert.AreEqual(result, expected);
Console.WriteLine(String.Format("Position: {0} => {1}", position.ToString(), result));
position = 36;
expected = "AJ";
result = ExcelHeader.getExcelColumnHeader(position);
Console.WriteLine(String.Format("Position: {0} => {1}", position.ToString(), result));
position = 41;
expected = "AO";
result = ExcelHeader.getExcelColumnHeader(position);
Console.WriteLine(String.Format("Position: {0} => {1}", position.ToString(), result));
position = 702;
expected = "ZZ";
result = ExcelHeader.getExcelColumnHeader(position);
Console.WriteLine(String.Format("Position: {0} => {1}", position.ToString(), result));
position = 703;
expected = "AAA";
result = ExcelHeader.getExcelColumnHeader(position);
Console.WriteLine(String.Format("Position: {0} => {1}", position.ToString(), result));
position = 18278;
expected = "ZZ";
result = ExcelHeader.getExcelColumnHeader(position);
Console.WriteLine(String.Format("Position: {0} => {1}", position.ToString(), result));
position = 18279;
expected = "AAAA";
result = ExcelHeader.getExcelColumnHeader(position);
Console.WriteLine(String.Format("Position: {0} => {1}", position.ToString(), result));
}
