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
原文地址:https://www.cnblogs.com/happygirl-zjj/p/4594738.html