using System.IO; using System; public class Program { public static void Main() { Console.WriteLine(ExcelColumnFromNumber(27)); } public static string ExcelColumnFromNumber(int column) { string columnString = ""; decimal columnNumber = column; while (columnNumber > 0) { decimal currentLetterNumber = (columnNumber - 1) % 26; char currentLetter = (char)(currentLetterNumber + 65); columnString = currentLetter + columnString; columnNumber = (columnNumber - (currentLetterNumber + 1)) / 26; } return columnString; } }
We use cookies to provide and improve our services. By using our site, you consent to our Cookies Policy. Accept Learn more