数字转换成excel列名（10进制到Exce..

                /// <summary>
                /// 10进制到Excel的26进制的转换函数
                /// </summary>
                /// <param name="i"></param>
                /// <returns></returns>
                private string convertToCharacter(int i)
                {
                        char[] list = "ABCDEFGHIJKLMNOPQRSTUVWXYZ".ToCharArray();
                        StringBuilder sb = new StringBuilder();
                        while ((i - 1) / 26 != 0)
                        {
                                sb.Append(list[i / 26 - 1]);
                                i = i % 26;
                        }
                        i = (i - 1) % 26;
                        sb.Append(list[i]);
                        return sb.ToString();
                } 转载于