Excel Sheet Column Number

Description:

Related to question Excel Sheet Column Title

Given a column title as appear in an Excel sheet, return its corresponding column number.

For example:

    A -> 1
    B -> 2
    C -> 3
    ...
    Z -> 26
    AA -> 27
    AB -> 28 

Code:

1  int titleToNumber(string s) {
2         int result = 0;
3         for (int i = 0; i < s.size(); i++)
4         {
5             result+=(s[i]-'A'+1)*(int)(pow((double)26,s.size()-i-1));
6         }
7         return result;
8     }
View Code

 

posted @ 2015-06-23 09:49  Rosanne  阅读(180)  评论(0编辑  收藏  举报