数字转换成excel列名（10进制到Excel的26进制的转换函数）

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

转载于 http://www.cnblogs.com/tionase/archive/2008/02/16/1070289.html

转载于:https://blog.51cto.com/824876/404536