Wednesday, 16 November 2011

convert Numbers to aphabets Useful for Excel

 static string CharacterIncrement(int colCount)
    {
        int TempCount = 0;
        string returnCharCount = string.Empty;

        if (colCount < 26)
        {
            TempCount = colCount;
            char CharCount = Convert.ToChar((Convert.ToInt32('A') + TempCount));
            returnCharCount += CharCount;
            return returnCharCount;
        }
        else
        {
            var rev = 0;

            while (colCount >= 26)
            {
                colCount = colCount - 26;
                rev++;
            }

            returnCharCount += CharacterIncrement(rev - 1);
            returnCharCount += CharacterIncrement(colCount);
            return returnCharCount;
        }
    }

No comments:

Post a Comment