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)); }