问一个excel数字和列名转换的问题

Question

写excel时 想做一个小函数参数 int 返回 string
例子 1 -> A
     2 -> B
     ...
     25-> Y
     26-> Z
     27-> AA
     ...谁有最简单的代码（最少代码量），或者某个函数包能解决此问题，谢谢

Answer 1

string rangeName = "";
            char[] columnName = {'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'};
            if (column > 26)
            {
                rangeName = string.Format("{0}{1}", columnName[column / 26 - 1], columnName[column % 26 - 1]);
            }
            else
            {
                rangeName = string.Format("{0}", columnName[column - 1]);
            }