【leetcode】Excel Sheet Column Number

Excel Sheet Column Number

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 

 

 1 class Solution {
 2 public:
 3     int titleToNumber(string s) {
 4        
 5         int n=s.length();
 6         int result=0;
 7         for(int i=0;i<n;i++)
 8         {
 9             int num=s[i]-'A'+1;
10             result=result*26+num;
11         }
12        
13         return result;
14     }
15 };

 

转载于:https://www.cnblogs.com/reachteam/p/4190285.html