【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 };

 

posted @ 2014-12-28 19:01  H5开发技术  阅读(236)  评论(0编辑  收藏  举报