Convert Excel column to Integer

public static int ColumnNumber(string colAdress)
{
int[] digits = new int[colAdress.Length];
for (int i = 0; i < colAdress.Length; ++i)
{
digits[i]
= Convert.ToInt32(colAdress[i]) - 64;
}
int mul = 1; int res = 0;
for (int pos = digits.Length - 1; pos >= 0; --pos)
{
res
+= digits[pos] * mul;
mul
*= 26;
}
return res;
}

 

posted on 2010-11-09 10:47  三十没立  阅读(179)  评论(0)    收藏  举报

导航