How do I find the Excel column name that corresponds to a given integer? [duplicate]

Question

How would you determine the column name (e.g. "AQ" or "BH") of the nth column in Excel?

Edit: A language-agnostic algorithm to determine this is the main goal here.

Answer 1

I once wrote this function to perform that exact task:

public static string Column(int column) {     column--;     if (column >= 0 && column < 26)         return ((char)('A' + column)).ToString();     else if (column > 25)         return Column(column / 26) + Column(column % 26 + 1);     else         throw new Exception("Invalid Column #" + (column + 1).ToString()); } 

Answer 2

Here is the cleanest correct solution I could come up with (in Java, but feel free to use your favorite language):

String getNthColumnName(int n) {     String name = "";     while (n > 0) {         n--;         name = (char)('A' + n%26) + name;         n /= 26;     }     return name; } 

But please do let me know of if you find a mistake in this code, thank you.