C#将数字转正字母的方法

最新推荐文章于 2022-07-18 20:18:48 发布

Royi666

最新推荐文章于 2022-07-18 20:18:48 发布

阅读量3.2k

点赞数

分类专栏： C# 文章标签： Excel字母列

本文链接：https://blog.csdn.net/sunroyi666/article/details/51862198

版权

C# 专栏收录该内容

18 篇文章 0 订阅

订阅专栏

将列号（数字）转换成Excel的字母列名
如
1→A
28→AB

实现：

private string getCellCode(int inCell)
{
    string strRet = "A";
    if (inCell >= 1 && inCell <= 256)
    {
<span style="white-space:pre">	</span>if (inCell <= 26)
        {
<span style="white-space:pre">	</span>    Byte[] bytes = new Byte[] { (byte)(inCell + 64) };
            ASCIIEncoding ascii = new ASCIIEncoding();
            strRet = ascii.GetString(bytes);
        }
        else
        {
<span style="white-space:pre">	</span>    int int1 = 0;
            int int2 = 0;
<span style="white-space:pre">	</span>    if (inCell - (int)(inCell / 26) * 26 == 0)
<span style="white-space:pre">	</span>    {
<span style="white-space:pre">		</span>int1 = (int)(inCell / 26) + 63;
<span style="white-space:pre">		</span>int2 = 90;
            }
     <span style="white-space:pre">	</span>    else
     <span style="white-space:pre">	</span>    {
      <span style="white-space:pre">		</span>int1 = (int)(inCell / 26) + 64;
      <span style="white-space:pre">		</span>int2 = (inCell - (int)(inCell / 26) * 26) + 64;
            }
            Byte[] bytes = new Byte[] { (byte)int1, (byte)int2 };
            ASCIIEncoding ascii = new ASCIIEncoding();
            strRet = ascii.GetString(bytes);
    <span style="white-space:pre">	</span>}
    }
    return strRet;
}